I am tasked to create an application that handles inspection for inventory. The inventory has hundreds and even thousands of customized needs for each individual project inspection. I have currently tried to standardize the process so that I can use a single form for multiple different products. I have learned that there are ways to auto-populate forms based on using a reference where I select a product from a master table of the listed products which has been a step in the right direction. I am currently creating the inspection forms in google sheets by simpling using creating columns for each of my product needs. The issue is this isn’t very scalable and very time-consuming.
Are there any ideas out there on how to streamline this process using forms without having to manually hand-make and customize forms individually?
My current suspicion is that I would just use a lot of app formulas to create relationships between my data tables to create a master form that just auto-populates and dereferences the info I need dependent on the referenced product.