Formula for combining linked records

[cshenoy86]

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?

[kuovonne · Accepted solution]

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.

[cshenoy86]

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?