Help

Formula for combining linked records

Topic Labels: Automations Formulas
Solved
Jump to Solution
1011 2
cancel
Showing results for 
Search instead for 
Did you mean: 
cshenoy86
7 - App Architect
7 - App Architect

Is there an airtable formula that combines linked records from a column (say column 1) and another column (say column 2) and outputs it as linked records in column 3? 

 

If not formula is there a way to do this without scripting?

cshenoy
1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

A formula result cannot be linked records. However, you can use a formula to combine the values in other fields and then use an automation to copy the result to a linked record field. No scripting involved.

In general, you want to combine the values from the two initial linked record fields into a single comma separated list. You will also need to make sure that each value in the list is unique in the target table and there are no repeats in the list. If values have commas, quotes, or other special characters, they may need special handling.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

A formula result cannot be linked records. However, you can use a formula to combine the values in other fields and then use an automation to copy the result to a linked record field. No scripting involved.

In general, you want to combine the values from the two initial linked record fields into a single comma separated list. You will also need to make sure that each value in the list is unique in the target table and there are no repeats in the list. If values have commas, quotes, or other special characters, they may need special handling.

Thank you for your response. There can be duplicates in the comma separated list but I noticed that when copying to the linked records, only 1 unique record is pasted. Is there some other handling that I would need to use?

cshenoy