duplicating a recored and its linked filed.

Topic Labels: Automations
300 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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:

  1. Create a new record and update it with all the fields.
  2. Search the other table for all the records that are linked to this one.
  3. 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?

1 Reply 1

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