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

Arcade Expression Help-Conditional Table

evtguy

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

Encuentra más publicaciones etiquetadas con

Accepted answers

KellyGerrow

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

All comments

KellyGerrow

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

evtguy

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.

evtguy

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:")

kenbuja

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

evtguy

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.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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