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

[DPM_reports]

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…

[Chris_Jeal]

Hi @DPM_reports,

Have you tried creating a dashboard for your forms?

This post can give you an overview.

[Lynn]

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-f...