topic Re: Can i eliminate empty values using arcade in my pop up? in ArcGIS Online Questions

Can i eliminate empty values using arcade in my pop up?

KevinMilton — Wed, 08 May 2019 19:07:06 GMT

I am attempting to create a conditional arcade expression that will list all of the fields that do not have a null value with an individual label and not show the field at all if the field is null. My current expression is below.

if (IsEmpty($feature.ABARTA_WI)){
return ""
} else {
return "Abarata: "+$feature.ABARTA_WI
}

This expression works in that it does not show the label or null value, but in the ArcGIS Portal pop up, it leaves an empty line for each one that is null, and i need it to not be there at all so the pop up is clean. As you can see below, this is creating empty lines in the popup.

I would prefer the popup to display something like below, eliminating the empty lines.

Chief: 0.28

Chief WI MKR: 0.28

Enerplus: 0.3

arcade expression‌ arcade pop-ups‌conditional pop ups‌

Any help would be greatly appreciated.

Thank you

Re: Can i eliminate empty values using arcade in my pop up?

XanderBakker — Wed, 08 May 2019 20:05:25 GMT

You can, but it will require multiple expressions and some html to do this (if you want to show it using html). Or you can create a larger expression that constructs the text to display and omits empty values.

Re: Can i eliminate empty values using arcade in my pop up?

KevinMilton — Wed, 08 May 2019 20:09:34 GMT

Well I need this popup to look professional so this is what i need to do. Can you provide further information on what that larger expression would look like?

Re: Can i eliminate empty values using arcade in my pop up?

KenBuja — Wed, 08 May 2019 20:20:37 GMT

Take a look at this blog on how to customize your popup: https://community.esri.com/community/gis/web-gis/arcgisonline/blog/2017/07/18/conditional-field-display-with-arcade-in-pop-ups

Re: Can i eliminate empty values using arcade in my pop up?

XanderBakker — Wed, 08 May 2019 21:29:33 GMT

Apart from the post mentioned by Ken, there are some comments that will be relevant for you:

https://community.esri.com/community/gis/web-gis/arcgisonline/blog/2017/07/18/conditional-field-display-with-arcade-in-p… (using text colors based on the value of an attribute)
https://community.esri.com/community/gis/web-gis/arcgisonline/blog/2017/07/18/conditional-field-display-with-arcade-in-p… (hiding elements when they do not have information)

Re: Can i eliminate empty values using arcade in my pop up?

MarkBockenhauer — Wed, 08 May 2019 22:39:42 GMT

Using something similar to what you have, you could use an approach like this.

{expression/expr1}

var a = $feature.notes
var b = $feature.popper
var attributes = ""
If (!IsEmpty($feature.notes)){
attributes = a + TextFormatting.NewLine + b
}
else {
attributes = b
}
return attributes

If Feature notes attribute is not Empty Show both attributes.

Else show one attribute

Mark

Re: Can i eliminate empty values using arcade in my pop up?

KevinMilton — Fri, 24 May 2019 14:52:45 GMT

UPDATE!!

This is a confirmed bug, and the arcade script will not produce the results we are asking for. This bug is not repaired until the 10.7 license level.

Re: Can i eliminate empty values using arcade in my pop up?

XanderBakker — Fri, 24 May 2019 15:14:13 GMT

Can you share the number of the bug and the description?

Re: Can i eliminate empty values using arcade in my pop up?

KevinMilton — Thu, 27 Jun 2019 14:26:09 GMT

BUG-000122554

In Portal for ArcGIS Map viewer, an Arcade Expression to configure fields in a pop up does not honor the TextFormatting.NewLine

Re: Can i eliminate empty values using arcade in my pop up?

GeraldSneary — Sat, 11 Dec 2021 16:30:53 GMT

Xander Bakker

Kevin Milton

Ken Buja

I can write one-off conditional expressions but how do you combine multiple conditional expressions for different fields? In the example below Field 1 & 2 are from one layer and Field 3 is from the popup layer. I want to only return a value and if it is null do not return an empty space. I can write an expression for each field that is null and only return the other 2 or all 3 if all values are present but not how to combine all expressions.

Field1 Field1 or Field2 or Field1 or Field3 and so on

Field2 Field2 Field3 Field3

Field3

I know how to return all fields even if it's null but it leaves a space/s.

This is my expression:

var buildn = FeatureSetByName($map,"NLCOG Buildings",["BUILDING_N"])
var fsIntersectbuild = Intersects(buildn, $feature)
var fbuildn = first(fsIntersectbuild)

var buildu = FeatureSetByName($map,"NLCOG Buildings",["USAGE_"])
var fIntersectbuild = Intersects(buildu, $feature)
var fusage = first(fIntersectbuild)

var occp = $feature.OCCUPANCY

iif (fbuildn.BUILDING_N == null, fusage.USAGE_ + TextFormatting.NewLine + occp, fbuildn.BUILDING_N + TextFormatting.NewLine + fusage.USAGE_ + TextFormatting.NewLine + occp)
//iif (fusage.USAGE_ == null, fbuildn.BUILDING_N + TextFormatting.NewLine + occp, fbuildn.BUILDING_N + TextFormatting.NewLine + fusage.USAGE_ + TextFormatting.NewLine + occp)
//iif (occp == null || occp == 'SINGLEF', fusage.USAGE_ + TextFormatting.NewLine + fbuildn.BUILDING_N, fbuildn.BUILDING_N + TextFormatting.NewLine + fusage.USAGE_ + TextFormatting.NewLine + occp)‍‍‍‍‍‍‍‍‍‍‍‍‍

Each one of the iif statements works independently. I've tried using the When function but each field is different so it doesn't work or not the way that I wrote it.

Any help would be appreciated.

Re: Can i eliminate empty values using arcade in my pop up?

XanderBakker — Sat, 11 Dec 2021 16:30:56 GMT

Hi Gerald Sneary

I just answered your question at the Kelly's blog, but looking at the example pop-up, this is something that could be solved in the expression and has no need for table and rows.

Have a look at the following example:

var val1 = "A";
var val2 = Null;
var val3 = "Test";

var lst = [val1, val2, val3];
var result = "";
for (var i in lst) {
    If (!IsEmpty(lst[i])) {
        if (result == "") {
            result = lst[i];
        } else {
            result += TextFormatting.NewLine + lst[i];
        }
    }
}

Console("### start ###");
Console(result);
Console("### end ###");

return result;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

This will write the following text to the Console:

### start ###
A
Test
### end ###‍‍‍‍

It will not create a line of the value is empty.

Re: Can i eliminate empty values using arcade in my pop up?

GeraldSneary — Fri, 20 Dec 2019 16:39:52 GMT

Xander you are a lifesaver. Thank you so much!

My hunch was right a list was needed. I just started learning code a month ago. I was about to break out LP3THW and start looking at lists. But I know I wouldn't have come up with your syntax.

Too bad you don't live closer I'd take you out for a few beers.

Re: Can i eliminate empty values using arcade in my pop up?

XanderBakker — Fri, 20 Dec 2019 16:44:02 GMT

Hi gerald.sneary80 ,

I'm glad to have helped. I also just posted a small document on how to hide rows in a table in case you need that:

Conditional Field display with Arcade in Pop Ups (with Arcade)

Re: Can i eliminate empty values using arcade in my pop up?

SarahFox1 — Mon, 27 Jul 2020 16:55:42 GMT

How can this be done with hyperlinks? I have a list of landmarks that have different types of websites for their documentation to relate back to. The table method worked beautifully, until I added a hyperlink to each one, then it spaced everything out again.

Re: Can i eliminate empty values using arcade in my pop up?

XanderBakker — Mon, 27 Jul 2020 20:44:20 GMT

Hi sjohnson_CityofLubbock ,

Is it possible to share the expression you have so far and he configuration of the pop-up?

Re: Can i eliminate empty values using arcade in my pop up?

SarahFox1 — Mon, 27 Jul 2020 23:15:34 GMT

I actually figured it out based on an article of yours I found combined with another article! It was really easy to follow and now my popups look spectacular! Thank you!
Conditional Field display with Arcade in Pop Ups (revisited)
Hyperlink within expression of pop-up in AGOL

This is the expression I ended up using:
IIF(isEmpty($feature["NRHP_Site"]),"none", "National Register of Historic Places");

And the table HTML:

<tr style="display: {expression/expr8}">
<td><a href="{NRHP}">National Register of Historic Places</a></td>
</tr>

When I went to copy it though - it had changed to this:

<tr style="display: {expression/expr1}">
<td><a>National Register of Historic Places</a></td>
</tr>

So that's a bit wierd.

Re: Can i eliminate empty values using arcade in my pop up?

XanderBakker — Mon, 27 Jul 2020 23:47:44 GMT

Hi sjohnson_CityofLubbock ,

The most important thing is that you made it work. But indeed, it is strange that it would change after copying. Let me know if you run into any problems and we'll see if we can figure it out.

Re: Can i eliminate empty values using arcade in my pop up?

rbasgall — Thu, 04 Aug 2022 21:50:18 GMT

I was looking all over for a solution that I could only display non null field values with the field alias and ended up combining a few different things I found.

Produces this:

Re: Can i eliminate empty values using arcade in my pop up?

ChrisRoberts2 — Tue, 16 Aug 2022 23:52:53 GMT

Thanks for this, its got me part way there 😊. However I noticed that it changes the order of the fields, is there a way to display it as per the schema order?

Re: Can i eliminate empty values using arcade in my pop up?

1stGreenFrequency — Tue, 10 Dec 2024 20:45:11 GMT

a Thank you from 2024 🙂