Oct 31, 2022 01:12 AM
I have a table that records data for truck checks that our employees perform. One of the fields are linked to another table that hold information of the individual vehicles. I had an automation that would automatically update the mileage of the vehicle selected in the vehicle table with the mileage that was enter on the truck check table. It worked great for a year but is now broken. I cannot figure out how to get it working again. Anyone have any advice as to how to set this up? The configuration is not very intuitive.
Nov 01, 2022 03:30 AM
Hi @Jacob_Conell, my guess is that new checks are entered via form or similar into the truck checks table?
If it’s a new record you’re taking the mileage info from, I would use that as a trigger. So run an automation where the trigger is “when record created”. Part of data that’s passed there should be the linked truck, so you can use a “find record” action to pull that record from the trucks table. Then you’ll use an “update record” action to update that truck record with the mileage info from the triggering record.
Let me know if that makes sense!
Nov 01, 2022 05:26 PM
are you getting a ‘received invalid inputs’ error in your automation?