Hello, I'm trying to write an expression that will return one of three image urls based on an inspection date. The distinction being the most recent date is less than 30 days, greater than 30 days, or there is no recent date. The expression is then pasted into the URL of an image for a pop up. Here is what I have so far. var relatedrecords = OrderBy ( FeatureSetByRelationshipName ( $feature , "AST_Inspection" ) , "insp_date DESC" ) ; var cnt = Count ( relatedrecords ) ; var relatedinfo = "" ; if ( cnt > 0 ) { var info = First ( relatedrecords ) ; relateddate = Text ( ToLocal ( info . insp_date ) , "MM/DD/Y" ) ; var diff = DateDiff ( Now ( ) , relateddate , "days" ) ; relatedinfo = IIf ( diff 30 , "img1url" , "img2url" ) ; } else { relatedinfo = "img3url" } return relatedinfo I tried nesting If/Else statements and it just kept giving the Else image url. I'm sure there is a simpler way to do this, but I'm not sure. Thanks.

I figured it out! Sorry to bug you. Turns out I was doing too much, and the DateDiff function was getting an error because of the text formatting of the insp_date. The code that works is as follows: var relatedrecords = Top ( OrderBy ( FeatureSetByRelationshipName ( $feature , "AST_Inspection" ) , "insp_date DESC" ) , 1 ) ; var cnt = Count ( relatedrecords ) ; var relatedinfo = "" ; if ( cnt > 0 ) { var info = First ( relatedrecords ) ; var diff = Round ( DateDiff ( Now ( ) , ToLocal ( info . insp_date ) , "days" ) ) ; relatedinfo = IIf ( diff 30 , "img1url" , "img2url" ) ; } else { relatedinfo = "img3url" } return relatedinfo Thanks for taking a look though!

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

Using Arcade Expressions to return image urls based on DateDiff

TimFlynn

Hello, I'm trying to write an expression that will return one of three image urls based on an inspection date. The distinction being the most recent date is less than 30 days, greater than 30 days, or there is no recent date. The expression is then pasted into the URL of an image for a pop up. Here is what I have so far.

<SPAN class="keyword token">var</SPAN> relatedrecords <SPAN class="operator token">=</SPAN> <SPAN class="token function">OrderBy</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">FeatureSetByRelationshipName</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"AST_Inspection"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"insp_date DESC"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> cnt <SPAN class="operator token">=</SPAN> <SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>relatedrecords<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> relatedinfo <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>cnt<SPAN class="operator token">></SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">var</SPAN> info <SPAN class="operator token">=</SPAN> <SPAN class="token function">First</SPAN><SPAN class="punctuation token">(</SPAN>relatedrecords<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    relateddate <SPAN class="operator token">=</SPAN> <SPAN class="token function">Text</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">ToLocal</SPAN><SPAN class="punctuation token">(</SPAN>info<SPAN class="punctuation token">.</SPAN>insp_date<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"MM/DD/Y"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">var</SPAN> diff <SPAN class="operator token">=</SPAN> <SPAN class="token function">DateDiff</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Now</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> relateddate<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"days"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        relatedinfo <SPAN class="operator token">=</SPAN> IIf <SPAN class="punctuation token">(</SPAN>diff<SPAN class="operator token"><</SPAN><SPAN class="number token">30</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"img1url"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"img2url"</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>
    relatedinfo<SPAN class="operator token">=</SPAN> <SPAN class="string token">"img3url"</SPAN>    
<SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">return</SPAN> relatedinfo‍‍‍‍‍‍‍‍‍‍‍‍<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>

I tried nesting If/Else statements and it just kept giving the Else image url. I'm sure there is a simpler way to do this, but I'm not sure.

Thanks.

Najděte více příspěvků označených jako

Accepted answers

TimFlynn

I figured it out! Sorry to bug you. Turns out I was doing too much, and the DateDiff function was getting an error because of the text formatting of the insp_date. The code that works is as follows:

<SPAN class="keyword token">var</SPAN> relatedrecords <SPAN class="operator token">=</SPAN> <SPAN class="token function">Top</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">OrderBy</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">FeatureSetByRelationshipName</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"AST_Inspection"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"insp_date DESC"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> cnt <SPAN class="operator token">=</SPAN> <SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>relatedrecords<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> relatedinfo <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>cnt<SPAN class="operator token">></SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">var</SPAN> info <SPAN class="operator token">=</SPAN> <SPAN class="token function">First</SPAN><SPAN class="punctuation token">(</SPAN>relatedrecords<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">var</SPAN> diff <SPAN class="operator token">=</SPAN> <SPAN class="token function">Round</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">DateDiff</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Now</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token function">ToLocal</SPAN><SPAN class="punctuation token">(</SPAN>info<SPAN class="punctuation token">.</SPAN>insp_date<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"days"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        relatedinfo <SPAN class="operator token">=</SPAN> IIf <SPAN class="punctuation token">(</SPAN>diff<SPAN class="operator token"><</SPAN><SPAN class="number token">30</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"img1url"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"img2url"</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>
        relatedinfo <SPAN class="operator token">=</SPAN> <SPAN class="string token">"img3url"</SPAN>
<SPAN class="punctuation token">}</SPAN>
 <SPAN class="keyword token">return</SPAN> relatedinfo<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>

Thanks for taking a look though!

All comments

TimFlynn

Xander Bakker‌ any ideas where I'm going wrong?

XanderBakker

Hi Tim Flynn ,

The way you use "img1url", "img2url" and "img3url" in the expression will not return a field value, but just the text "img1url", "img2url" or "img3url".

In case these are fields in the related "info", you should use:

relatedinfo <SPAN class="operator token">=</SPAN> <SPAN class="token function">IIf</SPAN><SPAN class="punctuation token">(</SPAN>diff<SPAN class="operator token"><</SPAN><SPAN class="number token">30</SPAN><SPAN class="punctuation token">,</SPAN> info<SPAN class="punctuation token">.</SPAN>img1url<SPAN class="punctuation token">,</SPAN> info<SPAN class="punctuation token">.</SPAN>img2url<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

However, this is not applicable for line 10 ("img3url") since you wont have any related records.

TimFlynn

I am trying to get it to return those text values. The image urls will not be stored as fields, they'll be static. I've been able to get it to pass img2url but not img1url when the related field "insp_date" is less than 30 days old. Here's what I've got now, after realizing there was a bit of a syntax error before.

<SPAN class="keyword token">var</SPAN> relatedrecords <SPAN class="operator token">=</SPAN> <SPAN class="token function">OrderBy</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">FeatureSetByRelationshipName</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"AST_Inspection"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"insp_date DESC"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> cnt <SPAN class="operator token">=</SPAN> <SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>relatedrecords<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> relatedinfo <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>cnt<SPAN class="operator token">></SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">var</SPAN> info <SPAN class="operator token">=</SPAN> <SPAN class="token function">First</SPAN><SPAN class="punctuation token">(</SPAN>relatedrecords<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">var</SPAN> relateddate <SPAN class="operator token">=</SPAN> <SPAN class="token function">Text</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">ToLocal</SPAN><SPAN class="punctuation token">(</SPAN>info<SPAN class="punctuation token">.</SPAN>insp_date<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"MM/DD/Y"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">var</SPAN> diff <SPAN class="operator token">=</SPAN> <SPAN class="token function">DateDiff</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Now</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> relateddate<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"days"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        relatedinfo <SPAN class="operator token">=</SPAN> IIf <SPAN class="punctuation token">(</SPAN>diff<SPAN class="operator token"><</SPAN><SPAN class="number token">30</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"img1url"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"img2url"</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>
    relatedinfo<SPAN class="operator token">=</SPAN> <SPAN class="string token">"img3url"</SPAN>    
<SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">return</SPAN> relatedinfo‍‍‍‍‍‍‍‍‍‍‍‍<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>

TimFlynn

I figured it out! Sorry to bug you. Turns out I was doing too much, and the DateDiff function was getting an error because of the text formatting of the insp_date. The code that works is as follows:

<SPAN class="keyword token">var</SPAN> relatedrecords <SPAN class="operator token">=</SPAN> <SPAN class="token function">Top</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">OrderBy</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">FeatureSetByRelationshipName</SPAN><SPAN class="punctuation token">(</SPAN>$feature<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"AST_Inspection"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"insp_date DESC"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> cnt <SPAN class="operator token">=</SPAN> <SPAN class="token function">Count</SPAN><SPAN class="punctuation token">(</SPAN>relatedrecords<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> relatedinfo <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>cnt<SPAN class="operator token">></SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">var</SPAN> info <SPAN class="operator token">=</SPAN> <SPAN class="token function">First</SPAN><SPAN class="punctuation token">(</SPAN>relatedrecords<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">var</SPAN> diff <SPAN class="operator token">=</SPAN> <SPAN class="token function">Round</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">DateDiff</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Now</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token function">ToLocal</SPAN><SPAN class="punctuation token">(</SPAN>info<SPAN class="punctuation token">.</SPAN>insp_date<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"days"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        relatedinfo <SPAN class="operator token">=</SPAN> IIf <SPAN class="punctuation token">(</SPAN>diff<SPAN class="operator token"><</SPAN><SPAN class="number token">30</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"img1url"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"img2url"</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>
        relatedinfo <SPAN class="operator token">=</SPAN> <SPAN class="string token">"img3url"</SPAN>
<SPAN class="punctuation token">}</SPAN>
 <SPAN class="keyword token">return</SPAN> relatedinfo<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>

Thanks for taking a look though!

XanderBakker

Hi Tim Flynn ,

I'm glad it works now, but if I look at your expression, I still see the same things that in theory should not work. Did you share the correct expression? If this is correct, can you share a screenshot of how the result looks?

Tweed_ShireAdmin

Tim,
I am trying to do a similar thing but just wondering where you set the location of the image in arcade expression. I have the image i want to use loaded to AGOL so wanting to know how I i apply what you have done in my situation.
I am wanting to showthe image of a tick instead of the word Yes for values in the table.

This is the arcade expression i have but it just returns the text of the url

var display = $feature["COASTAL_WETLANDS"]=='YES'
return IIF(display, 'info.https://tweedsc.maps.arcgis.com/sharing/rest/content/items/ca99d3ee3c7248d5b4757422aedc45fb/data', '')

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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