topic Re: Exclude null values in Public Notification Instant App in ArcGIS Instant Apps Questions

Exclude null values in Public Notification Instant App

Matt-Barrett — Fri, 18 Aug 2023 15:02:07 GMT

I set up the new Public Notification Instant App for my assessing department to use to create abutters lists. Abutters lists are required for things like variance applications, wetlands filings, etc.

The problem arises in that in our assessing cama system, we have an [Owner} field and a {co_owner} field. Not every record has a value in {co_owner}, but many do, and in some cases they are vital. So I have to include both fields in the label output from the app. However, for the ones that don't have a {co_owner} value the labels are populated with the word "null" in that space. I'm looking for a way to exclude any line that has a <null> value in it. See sample in image.

I also need to exclude what we call the "condo main" records from the list. These are records used to store data relevant to the condo as a whole, like the master deed. But they don't need to be included in abutters lists.

Since the app itself has very little opportunities for customization, I assume to place to do this is at the layer level in the map? We don't have this issue in the Web App Builder public notification widget. But I'm trying to phase out that site. I like the instant app as a better solution for us, except for this issue.

Thanks!

matt

Re: Exclude null values in Public Notification Instant App

SarahMcDonald_Esri — Fri, 18 Aug 2023 16:52:07 GMT

Hi @Matt-Barrett ,

Do you use any arcade expressions in the pop-up that return the labels? Would it be possible to share a screenshot of your pop-up configuration?

Thanks!

Sarah

Re: Exclude null values in Public Notification Instant App

Matt-Barrett — Fri, 18 Aug 2023 17:01:51 GMT

No. I don't know arcade. It's just the field names but there's a space I can't delete apparently. It's like the top line is formatted as double-space except that's not an option so I don't know why it's there.

Re: Exclude null values in Public Notification Instant App

SarahMcDonald_Esri — Mon, 21 Aug 2023 21:29:24 GMT

Hi @Matt-Barrett

Can you take a screenshot of the pop-up configuration source text? You can access it by clicking on the source button in the text configuration in the pop-up configuration.

Thanks!

Sarah

Re: Exclude null values in Public Notification Instant App

MattyMaps — Thu, 31 Aug 2023 18:54:07 GMT

Hi Sarah.

I also get nulls. Iam using arcade expressions to access a related table.

Is this a current limitation?

Thanks

Re: Exclude null values in Public Notification Instant App

Matt-Barrett — Mon, 23 Oct 2023 20:28:34 GMT

Just realized I never answered you. I guess I got sidetracked for a while. Thank you for taking time to look at this for me!

Re: Exclude null values in Public Notification Instant App

MelissaNorthey — Mon, 14 Oct 2024 16:37:26 GMT

I see that this thread is old but I also have this issue. Was a resolution found? I have an expression giving a value to each record that has a confidential flag to read "CONFIDENTIAL". This is in the popups and also in the export of the public notification. The popup shows white space beneath the rest of the mailing data (which still bugs me slightly) but the export shows "null" for each record that is not confidential. The export (CSV) is extra ugly as it has the header name of expr0 rather than the name that I gave it when creating the Arcade expression. The same map is used in the old Web AppBuilder application with the Public Notification widget and it does not show "null" for each address label even in the CSV export.