topic Re: Dynamic Colouring in ArcGIS Survey123 Questions

Dynamic Colouring

Anonymous User — Thu, 21 Apr 2022 00:36:29 GMT

Hello

Good night, I've been trying to create a dynamic color, in which I put this code:
#ff7373 is red
#5ac18e is green
#E7E7E7 is gray

if(int(${perc1}>100), "#ff7373",
if(int(${perc1}<100), '#5ac18e','#E7E7E7'))

if it goes beyond 100% it's a color
if it doesn't pass it will be another

can you help me to understand why it never goes out of the gray color?

thanks

IsmaelChivite — Thu, 21 Apr 2022 00:39:21 GMT

You can attach your XLSFile to your question. It will help you get answers. Upload a simplified version of your survey to keep things easy.

Anonymous User — Thu, 21 Apr 2022 08:26:10 GMT

Good Morning I send xlsform in order to facilitate the understanding of the code thanks

DeonLengton — Thu, 21 Apr 2022 10:39:27 GMT

Your brackets were incorrectly placed.

if(int(${perc1})>100, '#ff7373',
if(int(${perc1})<100, '#5ac18e','#E7E7E7'))

This fixes it.

Anonymous User — Thu, 21 Apr 2022 10:51:52 GMT

its work, thanks