nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Survey123 Feature Report - Conditional Formatting based on answer

Jeff_VanEtten

Wondering if there is a way to create conditional formatting inside the feature report template based on a response. For example, if inside the survey it was recorded options of Priority A, B & C and this wanted to be displayed with Red, Amber and Green text, is there a way to use conditional formatting to do this? I know that it would be fairly easy to do in Excel, but not sure about how this would be done in Word Template (mail merge).

Thanks

Trouver plus de publications taguées avec

Accepted answers

Jeff_VanEtten

Well finally figured out a work around to this using conditional elements with some code that looks like this in a table:

${if invest_priority==”A”}Priority A ${/}${if invest_priority==”B”}Priority B ${/}

Not perfect, but its a workaround for the time being.

All comments

TCKauhi

It appears the solution is in this feed, thank you and disregard. Solved: Conditional (if / then / else) logic in Survey123 ... - Esri Community

TCKauhi

This was very helpful, thank you. We have it working for when values (integers) are greater or less than one value (refer to example below), however do you know what would the syntax be for a range of values? For example, if we want a certain formatting when the value is between >46 and <=60?

${if mobilize_mins <= 45} ${mobilize_mins} minutes ${/} ${if mobilize_mins >= 120} ${mobilize_mins} minutes ${/}

MathieuBoonen

I have found in order for this to work for me I have had to include quotation marks around the conditioned format data if it has spaces in the response, or introduce a hidden character as in an unscrore colored white if you dont want the quotes marks to appear in the response on the report as per: showing both methods

${if invest_priority==”A”}Priority_A${/}${if invest_priority==”B”}"Priority B"${/}

Jeff_VanEtten

Well finally figured out a work around to this using conditional elements with some code that looks like this in a table:

${if invest_priority==”A”}Priority A ${/}${if invest_priority==”B”}Priority B ${/}

Not perfect, but its a workaround for the time being.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.