Stuck trying to figure how to link tables

[SynopsisLabs]

Hi,

I am a Airtable newbie and am having a bit of a challenge figuring out how to properly link 2 tables.  

Table 1 (Vehicles) stores Vehicle data - Plate, Make, Model, etc.

Table 2 (Fuel Log) stores  - Plate, Litres and Fillup Date

I would like to include a field in Table 1 that shows the total litres for each vehicle.  I have tried linking by Plate (not sure if that is correct) and can't figure out how to show the total litres in table 1. I would also want to be automatically update the total in the Vehicles tables when a new row is added in the Fuel Log table.

Would appreciate any assistance.

Thanks

Steve

[TheTimeSavingCo · Accepted solution]

After you create the link between the fields, you can use a rollup with SUM() to get the total litres:

Link to base

--

re: I would also want to be automatically update the total in the Vehicles tables when a new row is added in the Fuel Log table.

You can handle this by using an automation to paste the value from the "Plate" field into the linked field to the "Vehicles" table.  How to trigger the automation will depend on how you're submitting data into "Fuel Log" though.  If it's via a form, then you can use the trigger "When record created". 

If you're keying stuff in via the Grid view / List view etc, you're going to need to create a checkbox field and trigger your automation off that.  At that point you may as well just manually copy and paste the value from "Plate" into the linked field though

[dilipborad · Accepted solution]

Hello @SynopsisLabs ,

The way @TheTimeSavingCo is designed is perfect.

But only a couple of improvements you can make. 

The first field(Primary field) of the Fuel Logs table can be used using Summary(formula), date(created) or AutoNumber.