I have an Audit Checklist that I’m trying to make an app for.
User will be entering the Date of Audit / Location of Audit and then around 30 Questions.
Each Question has a Score & Remarks that need to be entered.
I can think of 2 approaches to this;
Using one single form and one sheet :
This Form would have the Date of Audit / Location of Audit and All 30 Questions + Score + Remarks field. This would be tedious as I can’t use a repeating section or such and also I’ll have to maintain multiple columns on the sheet.
Using one form, 2 sheets & trigger :
Next option would be to have a Form (sheet) with Date of Audit & Location of Audit. On Submit, the row addition in the backend sheet would trigger entries for all 30 questions for that date (Date/Question/Score/Remarks) in another sheet. Then I can show these entries as Inline List. However, how will I filter the Inline List for the specific date so that I update only those records for the specific date?
Any other approach? Appreciate any suggestions.