I am making an inspections type form and have started to branch off from examples.
I have a series of Data Tables.
-
Projects (eg. This is a list of different houses that require different inspections on them)
-
Booked inspections that need to be completed (eg. Roof inspection at this address, at this date and time). This also has a related form, adding an entry books in the inspection. This also has a column called “status” which can either be “complete” or “incomplete”. Once booked it will default to “incomplete”
-
Logged inspections. To do this you click on the booked inspection and it takes you to a form prompting you to enter answers. eg. inspector, comments, pass/fail, photos etc.
I would like the saving of the logged inspection form to change the value of the “status” column to complete.
How can I do this?