Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Using Automations to update mileage of specific vehilces

120 2
Showing results for 
Search instead for 
Did you mean: 

I’m working on managing a fleet of vehicles and im trying to automate things that happen when my “Fuel Log” table is updated. Currently new records are entered via a form by my drivers, I would then like to have the Mileage and Engine Hours that were entered into the new record from that form update on a separate table that i store general information for each of my vehicles on.

Currently the tables are “Fuel Log” and “Assets”

“Fuel Log” houses a list of entries updated daily by drivers when recording their post trip information, it is ever expanding and I GROUP it by date.

“Assets” houses a static list of the vehicles we use, and is only there to contain general information about each vehicle, VIN, Mileage, make, model etc. There are never any new records in this table, only updates to specific records in this table.

Im trying to figure something out like this.

Record created for Vehicle 12 in “Fuel Log” Table via a form for “Fuel Log” Table.
Automation Triggers
Finds Record for Vehicle 12 in “Assets” Table
Automation Updates “Mileage” & “Engine Hours” based on the newly created record in “Fuel Log”

2 Replies 2

Make Vehicle field linked. Use rollup in Assets field (dynamic update w/o auto). Or add trigger in Assets when linked field value changed

THANK YOU ive spent forever trying to figure this out, youre a life saver.