Multi step survey testing

Hi, I’m working on a ‘brand score’ app in Glide Pages. The intent is for brand managers or entreprenuers to take a survey that scores the health of their brand. They can then take the survey every few months and track changes over time. https://brandscore.glide.page/

This is a version one, and seems to work, so I’m hoping a few of you can test it out and share some feedback.

The survey has 25 questions, and to get this to work, I created a separate sheet and screen for each question. So, while it functions, it was very time-consuming. I have a feeling there’s a better way to build this functionality but haven’t quite figured it out yet. So open to ideas too!

Is there a way for you to do this within 1 sheet instead, maybe with multiple columns to store all answers?

Probably, but I haven’t quite been able to figure it out yet. The app functionality is based off the Field Sales template - so instead of adding items to an order, then submitting that order; users are adding answers to their assessment, then submitting the assessment at the end. I also had to link each answer a score to add up at the end, and I only wanted to only show one question at at time.

So this is my solution for now, but I’m sure there is a more efficient way to do it.