Help

Using Automations to update mileage of specific vehilces

Solved
Jump to Solution
489 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Micheal_Winfree
5 - Automation Enthusiast
5 - Automation Enthusiast

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”

1 Solution

Accepted Solutions
Alexey_Gusev
12 - Earth
12 - Earth

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

See Solution in Thread

2 Replies 2
Alexey_Gusev
12 - Earth
12 - Earth

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

Micheal_Winfree
5 - Automation Enthusiast
5 - Automation Enthusiast

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