topic Re: How to hide blank field in AGOL in ArcGIS Instant Apps Questions

How to hide blank field in AGOL

Anonymous User — Tue, 20 Jun 2017 15:32:35 GMT

I have a country table where some attribute data where some of the complete data fields are applicable and some are not so the field is blank <Null>. For example, tick-borne encephalitis in only applicable in 10 countries so it is blank in the other 242 countries. How to I configure a popup in AGOL to display the field (tick-born encephalitis) when data is present and not display it which the field is empty?

Re: How to hide blank field in AGOL

JakeSkinner — Tue, 20 Jun 2017 17:02:12 GMT

Hi Stephen,

Currently, there is not an out-of-the-box solution for this.

Would applying a unique symbology to the layer help at all? You could have one color indicate there are tick-born encephalitis, and another color indicate those that are NULL.

Re: How to hide blank field in AGOL

SteveMcCord — Tue, 20 Jun 2017 17:15:31 GMT

Jake, Thanks for the response. I'm using multiple fields each for specific immunizations which are linked to sites like the WHO, CDC, & NHS for more specific details.

Re: How to hide blank field in AGOL

Anonymous User — Fri, 30 Jun 2017 17:09:31 GMT

Hey Jake, can this be done with Arcade? If {field2} is 'null', then don't display {field1} in popup?

Re: How to hide blank field in AGOL

JakeSkinner — Mon, 03 Jul 2017 15:34:08 GMT

I just took a quick a look at this, I don't think this is possible using Arcade either. Creating an expression for a pop-up using Arcade will add a new field to your pop-up that will display the new information (i.e. field1 + field2).

Re: How to hide blank field in AGOL

Anonymous User — Wed, 02 Aug 2017 18:13:41 GMT

It seems that three statements are needed to get this done. I went to the ArcGIS Online guys at UC and we came up with the following 3 scripts. What I'm looking for is a wild card to add to the $feature.[field] so the script would roll through the list of values in the popup and display only those fields which are not null. It would seem the addition of a wildcard would allow this to happen in the $feature.field.

Any other thoughts?

Creates the label

if (IsEmpty($feature.Field1)){
return ""
} else {
return "Field 1"
}

Returns Field 1 value

if (IsEmpty($feature.Field1)){
return ""
} else {
return $feature.Field1
}

Converts to URL

if (IsEmpty($feature.Field1)){
return ""
} else {
return "Field2"
}

Re: How to hide blank field in AGOL

GeoffroyRicher-Lalonde1 — Tue, 13 Aug 2019 19:03:52 GMT

I managed to find a workaround that worked for me. I had a set of parks with Yes/No values on attributes like BASEBALL, FOOTBALL, etc. I wanted to show what are the available sports in every park, but without blank lines. So basically here are the steps :

Convert the Yes/No values into strings and null values with IIf statements, but add a separator ( like ; )
Concatenate into a big string
Split the big string into an array using the separators used in step 1
Count the number of sports for each park
Use some if/else if conditions to concatenate everything nicely (with new lines) for each specific number of sport.

Here is the code :

_________________________________

var arr = Split(
Concatenate(
IIf($feature.BASEBALL == 'Yes', ' • Baseball;', Null),
IIf($feature.BASKETBALL == 'Yes', ' • Basketball;', Null),
IIf($feature.FOOTBALL == 'Yes', ' • Football;', Null),
IIf($feature.SOCCER == 'Yes', ' • Soccer;', Null),
IIf($feature.TENNIS == 'Yes', ' • Tennis;', Null),
IIf($feature.VOLLEYBALL == 'Yes', ' • Volleyball;', Null)
),";");

var number = Count(arr);

if (number==1){
return '*** No sport in this park ***';
} else if (number==2){
return Text(Concatenate((arr[0]) + TextFormatting.NewLine + (arr[1])));
} else if (number==3){
return Text(Concatenate((arr[0]) + TextFormatting.NewLine + (arr[1]) + TextFormatting.NewLine + (arr[2])));
} else if (number==4){
return

...

...
} else {
return 'other';
}

Re: How to hide blank field in AGOL

Anonymous User — Thu, 30 Apr 2020 11:14:19 GMT

No, symbology is not the issue as the null values should not be shown. I think it can be done in arcade but I’m not sure how to do it with 20 variables in arcade.

Steve

Get Outlook<https://aka.ms/sdimjr> for iOS

Re: How to hide blank field in AGOL

JakeSkinner — Sun, 12 Dec 2021 08:57:41 GMT

Steve McCord‌ you can do this using a Custom Attribute pop-up. Below are the steps:

1. Choose A custom attribute display in the pop-up

2. Click the View HTML Source

3. Configure a span HTML element before any line that you do not want to display if it's NULL:

<b>Address:</b>  {FULLADDR}<br />
<span style="display:{expression/expr2}">
<b>Value:</b>  {PREDISVAL}
</span>‍‍‍‍

Update the expresssion/expr2 with the appropriate Attribute Expression

4. The Arcade for the Attribute Expression would be:

IIF(isEmpty($feature.PREDISVAL), "None", "inline")‍

This will then hide the field in the pop-up when the value is NULL:

Not sure if there is a way to simplify this for 20 different fields, but this should be a start.

Re: How to hide blank field in AGOL

Anonymous User — Thu, 30 Apr 2020 11:55:07 GMT

Thanks, Jake. Let me work through this and see how it functions.

Steve

Re: How to hide blank field in AGOL

MikieKelly — Sun, 12 Dec 2021 08:57:44 GMT

I use the following for hiding non-null fields in Popups:

var skipFields = ['Creator', 'CreationDate', 'Editor', 'EditDate', 'OBJECTID', 'GlobalID'];
var allFields = '';
for(var i in $feature){
    var skip = False;
    for(var j in skipFields){
        if(Text(i) == Text(skipFields[j])){
            skip = True;
        }
    }

    if(isEmpty($feature[i])){
        Console(Concatenate('Null Field: ', i));
    } else if (skip){
        Console(Concatenate('Skipping Field: ', i));
    } else {
        Console(Concatenate('Including Field: ', i));
        allFields = Concatenate([allFields, Upper(i), TextFormatting.NewLine, Text($feature[i]), TextFormatting.NewLine, TextFormatting.NewLine]);
    }
}

Console(allFields);
return allFields;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

It returns a basic output like this:

It does restrict the formatting of elements, but saves a lot of configuration as it can be used against any layer.

From my testing it does not display in Collector. I'm guessing it's because of the $feature reference, but haven't had a chance to look into it.

If you are worried about aesthetics, check out this blog. More work, but less raw!

Re: How to hide blank field in AGOL

DeborahCohen2 — Fri, 26 Jun 2020 14:07:16 GMT

Hi Jake,

I have a related question, this worked for me but one of my expressions is testing a Date field. It is configured as 12/12/20 in the configure attributes list, but the arcade expression changes the date format to this very lengthy format (first snip). I can't figure out why. Below is the IIf expression. Any ideas?

Thanks,

Deb

Arcade snip

Re: How to hide blank field in AGOL

JakeSkinner — Mon, 20 Jul 2020 23:55:29 GMT

Deborah Cohen‌ you can try returning the date as a string instead:

var editDate = Date($feature["last_edited_date"])
var stringDate = Text(editDate, 'MMMM, d, Y h: m :s')
return stringDate

Re: How to hide blank field in AGOL

BrunoRochaPA — Fri, 11 Feb 2022 13:17:01 GMT

Hi everyone,

I'm a beginner with Arcade, im trying to hide a blank fields on popups of a related table on AGOL, to visualize them on "details" - dashboad widget I would appreciate a lot your help and tips! 😄