Select to view content in your preferred language

Exclude null values in Public Notification Instant App

913
6
08-18-2023 08:02 AM
Matt-Barrett
Regular Contributor

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

abutter_list_example.png

6 Replies
SarahMcDonald_Esri
Esri Contributor

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

0 Kudos
Matt-Barrett
Regular Contributor

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.

abutter_map_popup_config.png

0 Kudos
MattyMaps
Regular Contributor

Hi Sarah.

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

Is this a current limitation?

Thanks

0 Kudos
SarahMcDonald_Esri
Esri Contributor

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. 

2023-08-21_14-26-55.png

Thanks!

Sarah 

0 Kudos
Matt-Barrett
Regular Contributor

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!

MattBarrett_0-1698092855745.png

 

0 Kudos
MelissaNorthey
Frequent Contributor

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.

0 Kudos