topic Re: Survey123 Feature Reports - Conditional format question in ArcGIS Survey123 Questions

Survey123 Feature Reports - Conditional format question

TCKauhi — Thu, 10 Aug 2023 20:41:18 GMT

We created a feature report in ArcGIS Online from a survey created in Survey123 Connect. We would like to format the text or table cell a different color based on the number reported in the survey. For example, 0-40% cell/text would be red, 40-80% cell/text would be orange, and greater than 80% cell/text would be green (refer to screenshot attached for example). Is this possible through feature reports? I have seen an example of putting records in separate tables, but we would like all of the results to be in 1 table. Thank you.

Re: Survey123 Feature Reports - Conditional format question

TCKauhi — Fri, 18 Aug 2023 23:15:31 GMT

It appears there are workarounds posted in these previous posts. Solved: Survey123 Feature Report - Conditional Formatting ... - Esri Community and Solved: Re: Conditional statement syntax in Survey123 repo... - Esri Community

Here is an example of the syntax to change colors based on value ranges:

${if mobilize_mins <= 45} ${mobilize_mins} minutes ${/} ${if mobilize_mins >=46 && mobilize_mins <=60} ${mobilize_mins} minutes ${/} ${if mobilize_mins >=61 && mobilize_mins <120} ${mobilize_mins} minutes ${/} ${if mobilize_mins >= 120} ${mobilize_mins} minutes ${/}

Re: Survey123 Feature Reports - Conditional format question

wprcevans — Wed, 25 Oct 2023 16:29:00 GMT

Any chance you could share a screen shot of how that looks in your word template?

Re: Survey123 Feature Reports - Conditional format question

EdKnowles — Mon, 25 Mar 2024 02:32:05 GMT

Is there a way to change the cell colour?

Re: Survey123 Feature Reports - Conditional format question

RobertAnderson3 — Mon, 25 Mar 2024 13:34:20 GMT

I wonder if you could set up conditional formatting on the table in Word and it processes based on what the value the report provides is?