How to create a single view for 6 diff sheets for updating

i have a Google sheet with 6 seperate forms across 6 seperate sheets…

I have created a starting point by creating a link to take the user to the form, which will be filled over the course of day…

now i want to know how to create a view where in 1 place i can see all the forms across 6 sheets in single place, so the user can select any of the pending forms to update in the day.

how can i achieve that…

Hi @DPM_reports,

Have you tried creating a dashboard for your forms?

This post can give you an overview.

1 Like

Hi @DPM_reports
You could also check out the Rig Check Inspection forms samples for ideas.
https://www.appsheet.com/samples/Monthly-inspection-forms-for-emergency-response-electrical-safety-fall-protection-and-stairways-and-walkways?appGuidString=f2391e01-fdbb-4091-9cdc-f094db2d9ce0

3 Likes