topic Re: Change Text Color Based on Value from Nested If Statement? in ArcGIS Survey123 Questions

Change Text Color Based on Value from Nested If Statement?

NEidenAZ — Tue, 14 Apr 2020 23:44:44 GMT

Hello! I'm wondering if it's possible to change the color of text based on the value from a nested If statement? I'm building a survey and based on a nested If statement, 3 answers are possible, which will in turn populate a Status field. If the facility is over capacity, I'd like the text to be Red, if at Capacity, Yellow, and if Below Capacity, Green.

Thanks!

~Nikki Eiden, AZ Dept. of Health Services

James Tedrick‌

Re: Change Text Color Based on Value from Nested If Statement?

FC_Basson — Wed, 15 Apr 2020 09:11:48 GMT

Try changing the output text from the IF-statement to HTML formatted text e.g.

<font color="red">Over Capacity</font>‍

Re: Change Text Color Based on Value from Nested If Statement?

NEidenAZ — Wed, 15 Apr 2020 22:11:00 GMT

Thanks for the idea. I gave it a try, no luck. S123 didn't like it when I saved the excel. Have you successfully used this technique? Perhaps I got the syntax wrong?

Re: Change Text Color Based on Value from Nested If Statement?

FC_Basson — Thu, 16 Apr 2020 06:29:21 GMT

Try this:

if(${CurrentCapacity}>${Capacity_Total}, '<font color="red">OverCapacity</font>', 'Other')‍

Re: Change Text Color Based on Value from Nested If Statement?

NEidenAZ — Thu, 16 Apr 2020 23:20:11 GMT

Thanks again! no luck 😞 Would you happen to have a screen shot of this in a XLSForm?

Re: Change Text Color Based on Value from Nested If Statement?

CPoynter — Fri, 17 Apr 2020 01:15:22 GMT

Maybe another solution: https://community.esri.com/thread/229158-survey123-style-a-calculation-result

Re: Change Text Color Based on Value from Nested If Statement?

FC_Basson — Fri, 17 Apr 2020 04:01:00 GMT

I tried the syntax provided in a form and it worked.

And this is the output form.

I assume your nested IF statement is working as it should. See what happens if you add a "name" to your Status note.

Re: Change Text Color Based on Value from Nested If Statement?

FC_Basson — Fri, 17 Apr 2020 04:06:04 GMT

Based on the answer provided by Craig, what version of Survey123 Connect are you using?