Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Add records from one table to a single record in another table

Solved
Jump to Solution
1261 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Maria_Juliana_Y
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello, Airtable community.

I would like to know how I can automatically add the records in Table A to a single record in Table B.

I already connected the tables and what I want is that every time a new record is added in Table A, the records are automatically added to the connected field in Table B. I tried Automations, but I couldn’t figure out the process.

I appreciate any guidance in advance.

1 Solution

Accepted Solutions
Rupert_Hoffsch1
10 - Mercury
10 - Mercury

Hi @Maria_Juliana_Yepes !

So you have on record in Table B, which shall be linked to all records getting added in Table A.

This is possible with automations, but you’ll have to overcome the issue of overwriting the linked record field in Table B instead of adding to it.

The trigger for the automation:
image

The firs action step is the a “Find records” step, in which you search for the record in Table B (in order to know which records are already linked). You will have to create a field containing the record id first (formula field and the formula is simply RECORD_ID()). Then you use the record id of the single record in Table B to actually find that record in the action step:
image

The last step is then to update the record in Table B:
image

The trick here is to use the previous values of the linked field in Table B (which you’ll find from the “Find Records” step) and add the new record id (from the record that got created, step 1):
image

Let me know if you run into any issues setting this up :slightly_smiling_face:

See Solution in Thread

1 Reply 1
Rupert_Hoffsch1
10 - Mercury
10 - Mercury

Hi @Maria_Juliana_Yepes !

So you have on record in Table B, which shall be linked to all records getting added in Table A.

This is possible with automations, but you’ll have to overcome the issue of overwriting the linked record field in Table B instead of adding to it.

The trigger for the automation:
image

The firs action step is the a “Find records” step, in which you search for the record in Table B (in order to know which records are already linked). You will have to create a field containing the record id first (formula field and the formula is simply RECORD_ID()). Then you use the record id of the single record in Table B to actually find that record in the action step:
image

The last step is then to update the record in Table B:
image

The trick here is to use the previous values of the linked field in Table B (which you’ll find from the “Find Records” step) and add the new record id (from the record that got created, step 1):
image

Let me know if you run into any issues setting this up :slightly_smiling_face: