Hello, I have been trying to figure this out for days now with no luck! Any help would be greatly appreciated!
I am trying to use an automation to find several records that all have the same name. I want to take those records after they have been found and copy them over to another table. To be clear if the automation finds 4 records, then I want 4 records to be copied and I do not want them to be in the new table as 1 record with 4 in the linked record column. I have successfully found the records using an automation, but how would I copy those found records over to a new table.
Any help would be greatly appreciated! Thanks in advance!
This is, unfortunately, one of the many flaws of Airtable.
However, you can automate this with no coding at all using Make.com. It’s as simple as this screenshot below:
You can do this in Airtable using a system of automations, and a linked control table.
Your first “find records” automations finds the records and then creates a new record in the linked control table that links to all of those records. If four records are found, all four will be linked to one record in the control table. This will also fill in the backlink field in your original table for all four of the original records.
Your second automation is triggered when there is a value in the backlink field (the link to the control table). This automation has actions to creat the new record in you target table. It also has an update action to clear the backlink field to the control table.
@ScottWorld Unfortunately, I do not think the views would help because basically, I have an inventory base. In the inventory base, I have two tables that are for storing available items for my employees to add. The first has the specific items and the second has sub-items that should be in the box of the specific item.
The items in the “sub-items” table are linked to the items in the first table.
Basically, I wanted a table where I could have a form that calls the first item by selecting it from a list and then puts the sub-items in another table where they can be viewed individually. Does this make sense? The views would not work because the first and second tables are technically static/frozen and will not be changed, whereas the third table will be where the sub-assets are copied to, where the sub-assets will be their own asset where there could be several of the same items in the one box. Thanks for your help!
@kuovonne That worked great thank you! My only concern is that when the automation deletes the field, it reruns the second automation because it is watching for the field to be updated which it is when it is deleting. In other words, where I should only create 4 fields, it is actually creating 8 in total. Do you know how to solve this problem? Thanks!