Auto advance to empty fields

[wtsheetuser]

I have a long form that users fill out over the course of 6 weeks on average. I can't split it up because each field is entirely independent from the others but they get filled out in order. I can't split it up by time as many might get completed quickly and others might take weeks but the lengths vary. They also can't wait to fill it out until the end as I have tracking on when they edit what fields to make sure they're staying on track to finish ~6 weeks. The students are "technically" submitting the form each time of course, I just have another view that lets them re-edit the answers and they normally add new data to new columns instead of editing old data.

So the issue is that this form is very annoying to scroll through and fill out as the information you first see in the form is almost always the oldest and least relevant. What would make it nice is if the user was auto-advanced to the next empty field in the form.

Is that possible in AppSheets?

[Suvrutt_Gurjar · Accepted solution]

Thank you for all the details. Since the user may need to revisit the questions , please explore the approach shown in the video below.

Assuming each user has her/his own record to fill in the form, you could add an enumlist button at the top of each form tab as shown in the video below.  When the user selects the respective question number you can either show or hide that question using Show_If property of that field based on enumlist selection.

https://www.loom.com/share/6cd8db7e4011424eae4e3a00e6451701

In the first 5 questions in "First Page" the show if expression is IN("1",[QSelect]) for Q1 and so on.

In the next 5 questions in "Second Page", the show if expression is NOT(IN("6",[QSelect2])) for Q6 and so on.