I’m building an app that will display a lengthy survey to users (20+ questions, some multiple choice, some text, etc.). It would be great if there was a way to separate the questions onto different “pages” of the app so that it presented nicer to the end user.
It may be possible to create a sheet for each question, then create separate forms for each question. In my spreadsheet, I would then create a “bundled sheet” that takes all the values from the other sheets and puts them on the same line (for data collection/tallying afterwards).
Can anyone think of a better way to accomplish this? Ideally, Glide’s Form function could eventually add the ability to put columns on separate pages of the app and add Next/Previous buttons for navigation.
Edit: I just experimented a bit with doing a separate “Form” for each question, with a form button under each question, but it’s very clunky. The user has to hit the Submit button to first log their first answer, then hit the Next button to get to the next question. Failing to hit the submit button (which I can totally see happening) leads to answers not getting transferred to the sheet.\
Edit2: Another workaround is using the new Visibility settings — if q1 is not empty, show q2. The issue arises when a question on the survey is optional (may have an empty response). The workaround for this would be to provide a “prefer not to answer” option.