I have a table that is a check point table. It has check points that can be edited by an administrator. So for example it can have 20 check points, but these check points descriptions and names can change, as can the number of check points. These could change on a daily basis. There will never be more than say 30.
Then I have another table of e.g. cars. And when a new car is added, the user has to answer all the check point questions and say if they are ok on the car. If they are not ok they can add a comment or even a picture.
So far I have a car table, and a checkpoints table and a bridge table linking them. This bridge table has the comment column and picture column which allows the user to add specific comments and pictures for each checkpoint on each car.
When I set all this up using default behaviour for refs and add a car, the user then has to manually add a New entry for each checkpoint. Since the checkpoints are already defined in a table I don’t want the user to add them manually. I want the user to just have to answer each checkpoint question and add a comment.i.e. I want to present a form of all the checkpoints and when the user saves this, the relevant tables will be updated.
How would I go about this doing in appsheet?
Thanks in advance for any help.