Hi guys, I am in need of some help with this one.
I have an app for vehicle inspections and fuel logs.
I have the following three tables and fields(this is a simplified version):
When a user completes an inspection form or a fuel log form the respective vehicle_kms field is populated with an initial value from the “vehicle” table current_kms field and there are some validation checks in place to prevent data entry errors (i.e. can’t be less than current or significantly more). The user would then update the entry to the current reading.
When the form is submitted I want the value that is stored in the “inspections”/“fuel log” vehicle_kms field to be pushed into the current_kms field in the “vehicles” table. I have been trying to do this with actions and have been reading through the forums but can’t seem to figure it out.
I really appreciate any help you can offer.