topic Re: Arcade expression to change text color based on date in ArcGIS JavaScript Maps SDK Questions

Arcade expression to change text color based on date

AndrewSD — Wed, 24 Jun 2020 14:18:54 GMT

I need an arcade expression that changes the text color based on age. So if if the age is 5 days or less its green text, between 6-10 days its yellow and 11-15 days is red. I am not that experienced with arcade and I tried to find examples of what I wanted and I tired to make it but could not get it to work.

var val = $datapoint.Age;

var textColor ="green";
if (val <= 5);
result='green'

var textColor ="yellow";
if (val <= 10);
results='yellow'

var textColor ="red";
if (val >= 13);
results='red'

return results;

I am not sure how to made the range value of between 6-10 days.

Thank you for any help!

Re: Arcade expression to change text color based on date

KenBuja — Sun, 12 Dec 2021 02:59:38 GMT

You want to use if...else to test val for various values:

var val = $datapoint.Age;

if (val <= 5) {
  results='green'
} else if (val <= 10) {
  results='yellow'
} else if (val >= 13) {
  results='red'
} else {
  //what happens for values between 10 and 13?
}
return results;‍‍‍‍‍‍‍‍‍‍‍‍

Re: Arcade expression to change text color based on date

AndrewSD — Wed, 24 Jun 2020 15:10:43 GMT

Thank you!! I was trying to make it a range so less than 5 days is green, between 6-10 days is yellow and and that 13 should have been an 11 so anything older than 11 is red. I just don't know how to show the range greater than 6 and less than 10.

Thank you!!

Re: Arcade expression to change text color based on date

KenBuja — Sun, 12 Dec 2021 02:59:41 GMT

Here's what you need for your revised values:

var val = $datapoint.Age;

if (val <= 5) {
  results='green'
} else if (val <= 10) {
  results='yellow'
} else {
  results='red'
}
return results;‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

This if..else statement evaluates val and set the results variable for the first time the condition is true. So for a value of 6, the first if statement (val <= 5) isn't true, so it then tests it for the next condition (val <= 10). It meets that condition, so results is set to "yellow".

Re: Arcade expression to change text color based on date

AndrewSD — Wed, 24 Jun 2020 19:29:04 GMT

Thank you!!

Re: Arcade expression to change text color based on date

KenBuja — Wed, 24 Jun 2020 19:34:49 GMT

If this has answered your question, please click the "Mark Correct" button

Re: Arcade expression to change text color based on date

AndrewSD — Wed, 24 Jun 2020 19:37:18 GMT

I am trying to take advantage of Arcade in Dashboard Beta and one thing I wanted to do was get the date difference between creation date and now. I used the DateDiff(now, feature.date, 'day') but it doesn't apply this to the Age field and show up on my list. Any ideas?

Thank you!

Re: Arcade expression to change text color based on date

KenBuja — Wed, 24 Jun 2020 19:41:27 GMT

Isn't the age field just a number and not a date?

Re: Arcade expression to change text color based on date

AndrewSD — Wed, 24 Jun 2020 20:06:59 GMT

I created a field called age in my feature layer on a webmap and calculated that by using the datediff function but it is static. I was hoping that in the Dashboard setting I could create a arcade expression that would update my list widget (based on the feature layer) to reflect how old a request was. So from day to day it would say its 1 day old, 2 day old, etc. and then once passed 5 day would turn yellow to mark urgency to take care of that request.

Thank you!

Re: Arcade expression to change text color based on date

KenBuja — Wed, 24 Jun 2020 20:15:04 GMT

Take a look at this blog post:

https://community.esri.com/community/commercial/blog/2020/03/10/arcade-calculating-relative-time-for-popups-and-symbology

Re: Arcade expression to change text color based on date

AndrewSD — Wed, 24 Jun 2020 20:19:01 GMT

This is exactly what I was looking for! Thank you, you are a lifesaver!