Our use case: a volunteer Fire/EMS department. We do weekly rig checks of 5+ rigs. Our two ambulances have about 500 items that need to be checked for qty and expiration dates. Engines and Tenders have some overlap (med bag) but otherwise different items. Each week users basically need to “copy a template” of our items/qtys/locations for each rig, then check them off.
(regarding location, 500 items is too many for a single list so we break it down like External>DriverSide>Rear>JumpBag>Main Compartment>items… I think I have this figured it as elegantly as a rhino on roller skates.)
One option is to add a button to copy the template page to a Log page, aka page copy. The other option is to copy every row of the template into a master Log table. The page option seems easier but pages are not as simple to handle (unless I can make the Log page a table of subpages?). Pages show as big buttons on the parent page. Rows are more flexible but will duplicate a lot of data- rig#, date, checkedby, etc. Across every item. If we add 3k rows per week and want to keep if for a year I fear it will bog down.
I considered sub-items and a single big “checkbox canvas” but reporting is a nightmare. If our second medic unit hasn’t gone out is 3 months but went our understocked, we need to know who/when checked it last and what the results were.
Any advice or ideas are appreciated.
Thanks.