Hello AirTable team,
I’m using airtable to do some product pricing with complex formula and links between tables.
I’m having an issue with linking tables and more specifically linking one to multiple records (i have been able to link them one by one by hand but i need to do mode than 5000 (50*100records) linking which is a hustle to do by hand) ) .
As an exemple :
I have 2 bases, the first (table1) with price references ( resale value) of each car and the second one (table 2) with complex formulas that let us update price based on the state of the car (second hand, engine, accessories …)
The first base (table1) is updated through the API straight from our website , and the second one (table2) is linked to our price estimation tool. But when i update the price reference on table 1, I want it to update automatically the 100 records on table 2.
When I update a record on table 1, I want it to automatically update 100 records on table 2 (taking info from the record on table 1) without having to link records one by one (by hand).
Thanks a lot.