topic Re: Arcade Expression for Mailing Labels in ArcGIS Online Questions

Arcade Expression for Mailing Labels in Public Notification Widget

KellyArmstrong — Mon, 01 Jun 2020 13:53:42 GMT

Here are my fields: [building_number], [street_name], [street_type], [street_direction], [city], [state]

I am trying to create an expression where, if the field [building_number] is empty, don't show any fields.

Else, return something like this:

Resident

[building_number] [street_name] [street_type] [street_direction]

[city], [state]

Re: Arcade Expression for Mailing Labels

XanderBakker — Sat, 11 Dec 2021 09:52:34 GMT

Hi OakdaleGIS ,

Could you try this?

if (IsEmpty($feature["building_number"])) {
    return "";
} else {
    return "Resident" + TextFormatting.NewLine + 
    Concatenate([$feature["building_number"], $feature["street_name"], $feature["street_type"], $feature["street_direction"]], ' ') +
    TextFormatting.NewLine + $feature.city + ", " +  $feature.state;
}
‍‍‍‍‍‍‍

Re: Arcade Expression for Mailing Labels

KellyArmstrong — Thu, 04 Jun 2020 15:10:00 GMT

Xander,

It works great. Only issue is after the concatenation, the elements have no spaces between them...

Thank you very much!!

Re: Arcade Expression for Mailing Labels

KellyArmstrong — Thu, 04 Jun 2020 15:25:36 GMT

Xander,

It does work. I was just seeing the concatenation in Arcade, when I actually utilized the expression, it worked with spaces.

Many many thanks!

Re: Arcade Expression for Mailing Labels

KellyArmstrong — Thu, 04 Jun 2020 15:31:02 GMT

Xander,

Actually, now that I have used/called the expression in the "Public Notification" widget, it does not function:

Re: Arcade Expression for Mailing Labels

XanderBakker — Thu, 04 Jun 2020 18:59:02 GMT

Hi OakdaleGIS ,

Could you look at the actual content of the building number field where you see this behavior? I am using the IsEmpty function and when the field is not actually empty it will not work. If the field is string, please check that there are no spaces in this field, since it will not be detected as empty.

Re: Arcade Expression for Mailing Labels

KellyArmstrong — Fri, 05 Jun 2020 15:15:28 GMT

I am not finding any spaces. How would you check? Also, this is a service from our ArcGIS Server, not a hosted feature service from AGOL.

Re: Arcade Expression for Mailing Labels

MichaelVolz — Fri, 05 Jun 2020 16:17:56 GMT

Do you have access to the datasource of the AGS service to review the raw data in ArcMap/Pro to look for blanks?

Re: Arcade Expression for Mailing Labels

KellyArmstrong — Fri, 05 Jun 2020 16:47:49 GMT

Yes, the service is located here: Service

field: parcel_building_number ( type: esriFieldTypeString , alias: /\BLDG_NUM/\ , length: 10 )

Re: Arcade Expression for Mailing Labels

KellyArmstrong — Fri, 05 Jun 2020 17:38:54 GMT

I don't see any spaces...

Re: Arcade Expression for Mailing Labels

XanderBakker — Sat, 11 Dec 2021 09:52:37 GMT

Hi Kelly Armstrong ,

Thanks for sharing the link, but it seems that the server is not responding. Also thanks for confirming that the field is indeed string. The problem with spaces is that they are difficult to detect visually. If there is a space we could use Trim function to strip them from the field before testing if it is empty. That would change the expression like this:

if (IsEmpty(Trim($feature["building_number"]))) {
    return "";
} else {
    return "Resident" + TextFormatting.NewLine + 
    Concatenate([$feature["building_number"], $feature["street_name"], $feature["street_type"], $feature["street_direction"]], ' ') +
    TextFormatting.NewLine + $feature.city + ", " +  $feature.state;
}‍‍‍‍‍‍‍

If indeed there is a string this could resolve the issue.

Re: Arcade Expression for Mailing Labels

XanderBakker — Fri, 05 Jun 2020 21:10:06 GMT

Hi OakdaleGIS ,

Can you confirm that you used the exact same expression that I posted? If I look carefully at the result below, it would mean that the expression is executed only partially, since there should be a blank line between "RESIDENT" and ", MN".

Re: Arcade Expression for Mailing Labels

KellyArmstrong — Fri, 05 Jun 2020 21:10:37 GMT

Thank you. It works great in a popup, but when using it with the "Public Notification" widget, I get this:

Re: Arcade Expression for Mailing Labels

XanderBakker — Mon, 08 Jun 2020 13:17:49 GMT

Hi OakdaleGIS ,

This is due to the fact that the newline is not supported yet. This will come in the near future.

Re: Arcade Expression for Mailing Labels

KellyArmstrong — Thu, 15 Apr 2021 14:15:19 GMT

Any update on this?