
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 27, 2023 01:03 PM
I’m trying to use automation to copy a record and create duplicates of all the linked records in the original record. Here’s what I’m trying to do:
- Create a new record and update it with all the fields.
- Search the other table for all the records that are linked to this one.
- Use a repeating group to create a record in Table 2 and copy the information from each record that is linked to the new record.
Unfortunately, I’ve tried so many ways, but it’s not working. Could you please help me?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 28, 2023 05:41 AM
Sounds easy. I would clarify, and if you still have problem, please describe at which step.
1. all the fields Except linked field
2. Find all the records, linked to initial (which is trigger). 'Where {Link field} _has any of_ [Airtable record ID ]" (Dynamic from step 1)
3.Use list for repeating group, Create record in Tab2, choose each editable field, use value from 'Current item', the last is Linked field, insert Dynamic - choose step 2 (Create record in Table1) - Record ID
