I am making an inspections type form and have started to branch off from examples.
I have a series of Data Tables.
1. Projects (eg. This is a list of different houses that require different inspections on them)
2. 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"
3. 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?
LinkedIn
Twitter
