Select to view content in your preferred language

Survey123 Feature Reports - Conditional format question

841
4
Jump to solution
08-10-2023 01:41 PM
TCKauhi
New Contributor II

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.

0 Kudos
1 Solution

Accepted Solutions
TCKauhi
New Contributor II

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 ${/}

View solution in original post

0 Kudos
4 Replies
TCKauhi
New Contributor II

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 ${/}

0 Kudos
wprcevans
New Contributor

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

0 Kudos
EdKnowles
New Contributor III

Is there a way to change the cell colour?

0 Kudos
RobertAnderson3
MVP Regular Contributor

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?

0 Kudos