Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 07, 2022 05:11 PM
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!
Aug 07, 2022 05:22 PM
Unfortunately, that is not possible in Airtable unless you know JavaScript and write your own JavaScript code to do that (or hire one of the JavaScript experts in this forum to write the code for you).
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:
Aug 07, 2022 05:24 PM
Hello Scott thank you very much for your help! Do you know if this is possible in Make if I am unsure how many records there will be? For example, some runs there may be 3 records to copy and some runs there may be 6, it just depends. Thanks again!
Aug 07, 2022 05:26 PM
Yes, that’s how it works.
Aug 07, 2022 05:26 PM
Perfect thanks so much!
Aug 07, 2022 05:27 PM
Also, is there a reason that you need to do this? Perhaps there’s an easier way in Airtable to get what you want… such as using “views” instead of automations.
Aug 07, 2022 05:54 PM
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.
Aug 07, 2022 06:05 PM
@Jake_O For complete details on how to use the method that @kuovonne described above, I explain this in depth on this episode of the BuiltOnAir podcast:
Aug 07, 2022 06:21 PM
@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!
Aug 07, 2022 06:23 PM
Thank you for that solution as well! I will try it out and see if it works well!