nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to hide blank field in AGOL

Anonymous User

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?

Encontre mais publicações marcadas com

Accepted answers

All comments

JakeSkinner

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.

SteveMcCord

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.

Anonymous User

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

JakeSkinner

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).

Anonymous User

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"
}

GeoffroyRicher-Lalonde1

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';
}

Anonymous User

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

JakeSkinner

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:

<SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token"><</SPAN>b</SPAN><SPAN class="punctuation token">></SPAN></SPAN>Address:<SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token"></</SPAN>b</SPAN><SPAN class="punctuation token">></SPAN></SPAN>  {FULLADDR}<SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token"><</SPAN>br</SPAN> <SPAN class="punctuation token">/></SPAN></SPAN>
<SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token"><</SPAN>span</SPAN><SPAN class="style-attr language-css token"><SPAN class="attr-name token"> <SPAN class="attr-name token">style</SPAN></SPAN><SPAN class="punctuation token">="</SPAN><SPAN class="attr-value token"><SPAN class="selector token">display:</SPAN><SPAN class="punctuation token">{</SPAN>expression/expr2<SPAN class="punctuation token">}</SPAN></SPAN><SPAN class="punctuation token">"</SPAN></SPAN><SPAN class="punctuation token">></SPAN></SPAN>
<SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token"><</SPAN>b</SPAN><SPAN class="punctuation token">></SPAN></SPAN>Value:<SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token"></</SPAN>b</SPAN><SPAN class="punctuation token">></SPAN></SPAN>  {PREDISVAL}
<SPAN class="token tag"><SPAN class="token tag"><SPAN class="punctuation token"></</SPAN>span</SPAN><SPAN class="punctuation token">></SPAN></SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Update the expresssion/expr2 with the appropriate Attribute Expression

4. The Arcade for the Attribute Expression would be:

IIF<SPAN class="punctuation token">(</SPAN>isEmpty<SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">.</SPAN>PREDISVAL<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"None"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"inline"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

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.

Anonymous User

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

Steve

A0328_3-1652303522597.png

MikieKelly

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

<SPAN class="keyword token">var</SPAN> skipFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Creator'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'CreationDate'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Editor'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'EditDate'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'OBJECTID'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'GlobalID'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> allFields <SPAN class="operator token">=</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">for</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> i <SPAN class="keyword token">in</SPAN> $feature<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">var</SPAN> skip <SPAN class="operator token">=</SPAN> False<SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">for</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> j <SPAN class="keyword token">in</SPAN> skipFields<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
        <SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Text</SPAN><SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="token function">Text</SPAN><SPAN class="punctuation token">(</SPAN>skipFields<SPAN class="punctuation token">[</SPAN>j<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
            skip <SPAN class="operator token">=</SPAN> True<SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>
    <SPAN class="punctuation token">}</SPAN>

    <SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">isEmpty</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
        <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Concatenate</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Null Field: '</SPAN><SPAN class="punctuation token">,</SPAN> i<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>skip<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
        <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Concatenate</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Skipping Field: '</SPAN><SPAN class="punctuation token">,</SPAN> i<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
        <SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Concatenate</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Including Field: '</SPAN><SPAN class="punctuation token">,</SPAN> i<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        allFields <SPAN class="operator token">=</SPAN> <SPAN class="token function">Concatenate</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>allFields<SPAN class="punctuation token">,</SPAN> <SPAN class="token function">Upper</SPAN><SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> TextFormatting<SPAN class="punctuation token">.</SPAN>NewLine<SPAN class="punctuation token">,</SPAN> <SPAN class="token function">Text</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> TextFormatting<SPAN class="punctuation token">.</SPAN>NewLine<SPAN class="punctuation token">,</SPAN> TextFormatting<SPAN class="punctuation token">.</SPAN>NewLine<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="token function">Console</SPAN><SPAN class="punctuation token">(</SPAN>allFields<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">return</SPAN> allFields<SPAN class="punctuation token">;</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

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!

DeborahCohen2

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

BrunoRochaPA

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! 😄

Dashboard 2.jpg

Dashboard 1.jpg

Dashboard 3.jpg

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.