topic Re: Group Heading Conditional Formatting in ArcGIS Survey123 Questions

Group Heading Conditional Formatting

LaurenCammack01 — Mon, 24 Apr 2023 19:08:28 GMT

Is it possible to color code the group heading based off of pass/fail questions within the group? For example, I have to failed questions in a group, I would like the group header to be colored red. If all questions in the group have passed I would like it colored green.

I'm currently getting an error on my calculate field for the begin group. I am able to color code the heading of the specific question with the calculate field based on pass/fail.

I found this post, however it isn't mentioning anything regarding formatting based on questions within the group other than changing text.

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-groups-grids-and/bc-p/1280736#M5518

Re: Group Heading Conditional Formatting

abureaux — Mon, 24 Apr 2023 19:52:38 GMT

Also works with HEX colors.

Edit: In case it wasn't clear, you can use any logic you'd like/need. I just used a select_one as an example. The key is simply to replace the colored text (below) with a formula that will dynamically add the HEX/Color code:

Re: Group Heading Conditional Formatting

LaurenCammack01 — Mon, 24 Apr 2023 20:21:07 GMT

Great! Thank you so much. If I were to have multiple questions under a heading based on the pass/fail would I do a separate calculate field for the heading and then reference the name of the calculate field?

Re: Group Heading Conditional Formatting

abureaux — Mon, 24 Apr 2023 20:40:12 GMT

What I would do is set this up in stages: 1) Each question gets its own T/F logic, 2) SUM the individual questions, then 3) Use a logical test on that final SUM

In practical terms:

1) In this example, when someone answers "Bad" in one for the four questions, it results in a 1. Otherwise, the result is a 0.

2) Then, I SUM up all of my questions (four, in this case).

3) Finally, I perform a logical test. For my example here, I am assuming that if they answer "Bad" even once, then the color will be Red, otherwise it will be Green.

Re: Group Heading Conditional Formatting

PegGronemeyer1 — Mon, 24 Feb 2025 12:41:10 GMT

I had same question, thank you !!! @abureaux for the clear step by step explanation and the screenshots - they are so helpful and save a lot of time and frustration!