Need help with building a data base to collect building information. Basically, to create a program that uses forms to collect information regarding sites inspected such as space/room, materials that may contain environmental hazards, quantity of the material and then identify the samples collected (matching to the materials identified). Then provide reports from the data collected (on custom forms). I have started the process, but would like feedback and expertise on best practices. In addition, learning how to use airtable a bit better including, airtable database structure, scripts and organizing data to provide table reports.
I plan to do the work with support from someone who knows airtable much better than I do.
Thank you.
