Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 29, 2022 07:13 AM
I’m wondering if you can help.
I have two tables ‘Vehicles’ (a list of all vehicles, their type etc) and another ‘Bookings’ (dates, booking purpose) that has a linked field to ‘Vehicles’ allowing me to link multiple vehicles to one type of booking (via the primary field, which is a vehicle identifier unique to each vehicle)
Having a separate table for bookings saves me from having to continuously make endless date columns for each new booking.
I need to build an automation that does the following
Happy to use an extension if that will do the job. Thanks!
Solved! Go to Solution.
Jun 29, 2022 09:59 AM
This is the “correct” way to design your use case anyways, so good instincts there.
Linking two different(*) tables together creates reciprocal Link Fields. That means whenever you update the Link Field in the Bookings table, you are already updating a Link Field in the Vehicle table. Airtable creates and manages the reciprocal links for you, and the field may be hidden from whatever view you’re looking at in the Vehicles table.
Are you saying you need two links between Vehicles and Bookings? If so, the Automation setup would be pretty straight forward but if you only need one link between the tables then you don’t need an Automation at all.
(*) The only time Airtable doesn’t create/handle automatically reciprocal link fields if you link one table to itself.
Jun 29, 2022 09:59 AM
This is the “correct” way to design your use case anyways, so good instincts there.
Linking two different(*) tables together creates reciprocal Link Fields. That means whenever you update the Link Field in the Bookings table, you are already updating a Link Field in the Vehicle table. Airtable creates and manages the reciprocal links for you, and the field may be hidden from whatever view you’re looking at in the Vehicles table.
Are you saying you need two links between Vehicles and Bookings? If so, the Automation setup would be pretty straight forward but if you only need one link between the tables then you don’t need an Automation at all.
(*) The only time Airtable doesn’t create/handle automatically reciprocal link fields if you link one table to itself.