We are creating a vehicle inspection app. The...

[Jonathon]

We are creating a vehicle inspection app. There is a table of vehicles, which are referenced by a table of inspections.

Our users perform these inspections daily. If there is pre-existing damage on a vehicle, our users have to record the same damage every day to fill their forms out properly. This is tedious.

I was hoping to have a third table, inspection_damage, as an ‘is part of’ table that would contain all the past recorded damage records from all other users. Then, when performing new inspections, the techs could add to the list if new damage exists.

This table would have to reference the ‘inspections’ table, and therefor would be tied to that particular walkaround instance. So every new inspection will begin blank.

Is there a way to make this work so that upon creating a new record in a table called ‘inspection’, referenced to a specified vehicle, it will display a REF for that vehicle and a third table of outstanding damages?

[Harry2]

@Jonathon_Sinclair Another option is to create a “copy” action that will open a new form with pre-filled values based on an existing row. By clicking on this action button, the user will copy the information in an existing row into a new form. This sample app nicely demonstrates how to implement this using the LINKTOFORM expression:

appsheet.com - Linktoform Example - This app shows how to link to a form and fill in default values Linktoform Example - This app shows how to link to a form and fill in default values appsheet.com