I'm doing some testing for our Health Department, to see if Survey123 can meet their needs for going digital with their Food Inspections program.
As part of their inspections, there are multiple series of questions organized in groups. Within a single series, the paper form is laid out much like the table-list appearance type. However, not all the questions within the series can have all the options, but the remaining options will be the same.
Is there any way to accomplish a compact form like a table list in which users see the available choices in the same positions, but in which the choices available can change? Simply using two or more choice lists in S123 causes errors. Here's a mock-up:
I've tried using choice filters, which do effectively limit the choices available, but the positions are not held.
Am I just out of luck here?
Edit to add:
I have considered rearranging the questions into sub-groups, such that all questions with the choice combinations are in groups together, but this won't work. The order of questions on the inspection form was very deliberately chosen, so I can't change them like that. I need them to show up in the proper order, and have been asked to align the choices into the same columns regardless of what choices are available on a given question.
Solved! Go to Solution.
You can't do it with a table list, but you can mimic the effect by placing your questions in a grid and hiding the appropriate responses.
That is clever. I should be able to get a lot closer to the paper form's look and feel with this. Thanks for sharing the xls form!
Just to follow up, I wanted to let you know that this is definitely going to work for us. Coalescing the choices into a single field for each question is tedious to set up, but only has to happen once. The field crews, however, will see something familiar and orderly.
Thank you again!
You're right, selecting which answers to hide and then turning all those fields into a single response per "question" is slow, but as you say, it only needs to be done once.
Thanks for the follow up. Nice to know I'm helping.