Mar 12, 2021 12:04 PM
In one base I have three tables. One is for Manufacturers and another is for Products. Manufacturers records have a field that can link to multiple products from the Products table.
A third table is for special offers. The data is imported here from a separate list and it includes linked fields for both the Manufacturer and the Product.
When a record is added here it will add the Manufacturer and Product to their respective tables, if they don’t already exist. But it doesn’t automatically link the Product to the Manufacturer.
Is there any way to make that happen?!
Mar 12, 2021 12:15 PM
I got there manually by copying the Product and Manufacturer columns from the third table and pasting into the Products table. Not ideal and I’ll probably have a fair few duplicates now… automatic would be better!
Thanks for anyone’s help. :grinning_face_with_big_eyes:
Mar 16, 2021 08:10 AM
Hello and welcome to the Airtable Community @Stu_Smith!
I’d recommend looking into Airtable Automations as a recurring automatic solution to updating your records.
Utilizing Automations you can:
Using Airtable Automations should allow you to have a fully automatic workflow. :star2:
Mar 16, 2021 09:30 AM
Oooh… ok that all looks very interesting. I’ll dive in and see if I can work it out!
Mar 16, 2021 09:36 AM
Let me know if you have any additional questions as you dive in!
Also if my response answered your question could you do me a favor and mark the answer as a solution using the :white_check_mark: ?