I'm working on the Playground Inspections project for the City and we have 30 playgrounds to maintain and regularly inspect. I was planning to build the database schema as FGDB. The schema will be represented as a polygon FC (Playgrounds) and several related tables (Inspections, Vandalism, Accidents and Suppliers) all hosted on ArcGIS Online as we do not have Enterprise licence.
We decided to adopt CSA standards and I'm basing my Inspections table schema on a sample report from the Canadian Playground Safety Institute course manual. There are 33 aspects that needs to be considered in this report, each as a separate question or field name. One of questions is a Equipment Inventory list (see attachment). I'm trying to find a best and most efficient way of adding this list to my database schema and to Survey123 report to fill during field inspections.
select_multiple type of question will fit the bill but only partially as it does not have an option to track a number for each multiple answer. How should I go about this?