topic Re: Arcade Expression Help-Conditional Table in ArcGIS Online Questions

Arcade Expression Help-Conditional Table

SteveCole — Sun, 29 Apr 2018 05:31:18 GMT

I'm having trouble implementing what I want as a popup for a point layer. The points represent physical locations and basically store URLs to photos and video of the location. There are five photo URLfields (photo01, photo02, photo03, photo4, photo5) and five video URL fields (video01, video02, video03, video04, video05).

A site may have UP TO 5 photos or videos or it may have none. Because of this, ideally I'd like the attributes to adjust accordingly. For example, if a site has no photos and 2 videos, the popup would look like this:

Photos:

No Photos currently. Please Check back

Video:

Video 01: <url>

Video 02: <url>

I have some expressions which help me determine if the field is empty but I can't figure out how to incorporate that into a dynamic table in the popup.

Here'e the actual service layer link.

Any ideas?

Steve

Re: Arcade Expression Help-Conditional Table

KellyGerrow — Tue, 01 May 2018 00:12:05 GMT

Hey Steve,

Check out this blog, it may point you in the right direction:

https://community.esri.com/community/gis/web-gis/arcgisonline/blog/2017/07/18/conditional-field-display-with-arcade-in-pop-ups?sr=search&searchId=841d6770-775c-4345-9bfa-9630e41626a9&searchIndex=0‌

-Kelly

Re: Arcade Expression Help-Conditional Table

SteveCole — Tue, 01 May 2018 03:47:31 GMT

Thanks, but no- not really. I understand using Arcade, to a point, but AGOL doesn't seem to honor the HTML formatted output that I generate.

Here's my Arcade expression:

// Write a script to return a value to show in the pop-up.
// For example, get the average of 4 fields:
// Average($feature.SalesQ1, $feature.SalesQ2, $feature.SalesQ3, $feature.SalesQ4)
var popupText = 'Location: ' + $feature.unitName + ' 360 Degree Photos:<table>';
var counter=0;
var tableText = '';
var chkPhoto01Field = IsEmpty($feature["VR_IMG_URL"]);
var chkPhoto02Field = IsEmpty($feature["VR_IMG_U_1"]);
var chkPhoto03Field = IsEmpty($feature["VR_IMG_U_2"]);
var chkPhoto04Field = IsEmpty($feature["VR_IMG_U_3"]);
var chkPhoto05Field = IsEmpty($feature["VR_IMG_U_4"]);
var finalText = '';
if (chkPhoto01Field) {
counter = counter+1;
tableText = tableText + '<tr><td>Photo ' + counter + ':</td><td><a href="' + $feature["VR_IMG_URL"] + '" target="_blank">Click to View</a></td></tr>';
}
if (chkPhoto02Field) {
counter = counter+1;
tableText = tableText + '<tr><td>Photo ' + counter + ':</td><td><a href="' + $feature["VR_IMG_U_1"] + '" target="_blank">Click to View</a></td></tr>';
}
if (chkPhoto03Field) {
counter = counter+1;
tableText = tableText + '<tr><td>Photo ' + counter + ':</td><td><a href="' + $feature["VR_IMG_U_2"] + '" target="_blank">Click to View</a></td></tr>';
}
if (chkPhoto04Field) {
counter = counter+1;
tableText = tableText + '<tr><td>Photo ' + counter + ':</td><td><a href="' + $feature["VR_IMG_U_3"] + '" target="_blank">Click to View</a></td></tr>';
}
if (chkPhoto05Field) {
counter = counter+1;
tableText = tableText + '<tr><td>Photo ' + counter + ':</td><td><a href="' + $feature["VR_IMG_U_4"] + '" target="_blank">Click to View</a></td></tr>';
}
if (counter==0) {
tableText = '<tr><td colspan="2">No Content Currently. Please check back.</td></tr>';
}
finalText = popupText + tableText + '</table>';
return finalText;

and here's the resulting popup:

And here's how I set up the popup output:

Popups support HTML formatting but the end output just treats it as literal text.

Re: Arcade Expression Help-Conditional Table

SteveCole — Tue, 01 May 2018 06:35:24 GMT

UPDATE:

I rethought how my URLs are stored in my data which better positioned me to try the technique from the blog post. The results are close to what I want but not quite. Here's the HTML table in the popup config:

<table cellpadding="0px" cellspacing="3px">
<tbody>
<tr valign="top">
<td>Photos:</td>
<td> </td>
</tr>
<tr valign="top">
<td>{expression/expr8}</td>
<td><a href="{VR_IMG_URL}" target="_blank">Click to View</a></td>
</tr>
<tr valign="top">
<td>{expression/expr9}</td>
<td><a href="{VR_IMG_U_1}" target="_blank">Click to View</a></td>
</tr>
<tr valign="top">
<td>{expression/expr10}</td>
<td><a href="{VR_IMG_U_2}" target="_blank">Click to View</a></td>
</tr>
<tr valign="top">
<td>{expression/expr11}</td>
<td><a href="{VR_IMG_U_3}" target="_blank">Click to View</a></td>
</tr>
<tr valign="top">
<td>{expression/expr12}</td>
<td><a href="{VR_IMG_U_4}" target="_blank">Click to View</a></td>
</tr>
<tr valign="top">
<td>Videos:</td>
<td> </td>
</tr>
<tr valign="top">
<td>{expression/expr13}</td>
<td><a href="{VR_VID_URL}" target="_blank">Click to View</a></td>
</tr>
<tr valign="top">
<td>{expression/expr14}</td>
<td><a href="{VR_VID_U_1}" target="_blank">Click to View</a></td>
</tr>
<tr valign="top">
<td>{expression/expr15}</td>
<td><a href="{VR_VID_U_2}" target="_blank">Click to View</a></td>
</tr>
<tr valign="top">
<td>{expression/expr16}</td>
<td><a href="{VR_VID_U_3}" target="_blank">Click to View</a></td>
</tr>
<tr valign="top">
<td>{expression/expr17}</td>
<td><a href="{VR_VID_U_4}" target="_blank">Click to View</a></td>
</tr>
</tbody>
</table>

As you can see, it correctly notes that there is 1 photo and 1 video for this location but it does not hide the row from the table if the URL field is blank. The links for the valid media are correct & work and the links that shouldn't appear are "about:blank".

I'm using the same IIF logic per the blog post for each URL field. Example:

IIF(isEmpty($feature["VR_IMG_URL"]), "", "Photo 1:")

Re: Arcade Expression Help-Conditional Table

KenBuja — Tue, 01 May 2018 14:14:16 GMT

Your data has some inconsistencies. I tried two different IIF statements in different expressions.

IIF(IsEmpty($feature["VR_IMG_U_1"]), 'Not Present', "Photo 1") ("Is Empty" popup field)

and

IIF($feature["VR_IMG_U_1"] != ' ', 'Photo1', "Not Present") ("Quoted" popup field)

and I'm seeing different responses for different points. Here's the popups for two different points.

So then I added another expression to make the spaces visible

Replace($feature["VR_IMG_U_1"], " ", "x")

Here are the two popups again

Re: Arcade Expression Help-Conditional Table

SteveCole — Tue, 01 May 2018 15:05:06 GMT

Yes- I noticed an issue last night with the fields and thought I had fixed them prior to my last post. I discovered that the URL fields that I thought were empty actually contained a space. I attempted to remove them from my hosted layer but perhaps I did not do so correctly. I can update my hosted layer once I look at it in Arcmap. That does bring up something I discovered while working on this last night. There is no length function within Arcade, and that would have been more helpful for me instead of using isEmpty. I could have just evaluated a length > 3 to determine the presence of a URL in the field but alas.

Re: Arcade Expression Help-Conditional Table

KenBuja — Tue, 01 May 2018 15:16:14 GMT

Search for the "https" in the fields using Find instead.

Re: Arcade Expression Help-Conditional Table

SteveCole — Tue, 01 May 2018 15:18:03 GMT

Roundabout way but, yeah, that would work. Thanks.

Re: Arcade Expression Help-Conditional Table

KenBuja — Tue, 01 May 2018 15:26:55 GMT

Not really roundabout. You'd use the same logic as your previous IIF statement.

IIF(Find('https', $feature["VR_IMG_U_1"]) > -1, 'Photo 1', 'Not Present')

Re: Arcade Expression Help-Conditional Table

SteveCole — Tue, 01 May 2018 15:45:06 GMT

I meant that I was focused on looking at the length of field's value to determine if it was populated that I hadn't even considered that you could also just query for part of the URL and get the same, reliable (if not more accurate) result. Hopefully this change will get things the way I want. I'll check it out later today. Thanks again.

Re: Arcade Expression Help-Conditional Table

SteveCole — Wed, 02 May 2018 03:11:21 GMT

I had to do way to much work to get this work but I guess this will be as close as I'm able to get to what I want:

One glaring deficiency of using Arcade (for me, at least) is that any output that the Arcade Expression generates that includes HTML tag elements is NOT honored by the configuration screen. It simply passes it along as text. As such, for each row of my screen shot above, I needed to use two expressions- one for the actual URL of the link, and a second expression for the "Click to View" text of the <a> element. For both expressions, I simply used the IIF that Ken suggested based on the Find function.

The final config HTML was this:

<table cellpadding="0px" cellspacing="3px">
<tbody>
<tr valign="top">
<td colspan="2">SITE: {unitName} PHOTOS:</td>
<td> </td>
</tr>
<tr valign="top">
<td>Photo 1:</td>
<td><a href="{expression/expr8}" target="_blank">{expression/expr18}</a></td>
</tr>
<tr valign="top">
<td>Photo 2:</td>
<td><a href="{expression/expr9}" target="_blank">{expression/expr19}</a></td>
</tr>
<tr valign="top">
<td>Photo 3:</td>
<td><a href="{expression/expr10}" target="_blank">{expression/expr20}</a></td>
</tr>
<tr valign="top">
<td>Photo 4:</td>
<td><a href="{expression/expr11}" target="_blank">{expression/expr21}</a></td>
</tr>
<tr valign="top">
<td>Photo 5:</td>
<td><a href="{expression/expr12}" target="_blank">{expression/expr22}</a></td>
</tr>
<tr valign="top">
<td colspan="2">VIDEOS:</td>
<td> </td>
</tr>
<tr valign="top">
<td>Video 1:</td>
<td><a href="{expression/expr13}" target="_blank">{expression/expr23}</a></td>
</tr>
<tr valign="top">
<td>Video 2:</td>
<td><a href="{expression/expr14}" target="_blank">{expression/expr24}</a></td>
</tr>
<tr valign="top">
<td>Video 3:</td>
<td><a href="{expression/expr15}" target="_blank">{expression/expr25}</a></td>
</tr>
<tr valign="top">
<td>Video 4:</td>
<td><a href="{expression/expr16}" target="_blank">{expression/expr26}</a></td>
</tr>
<tr valign="top">
<td>Video 5:</td>
<td><a href="{expression/expr17}" target="_blank">{expression/expr27}</a></td>
</tr>
</tbody>
</table> (Links Open in a New Window )

Thanks everyone.