How can I paste multiple records into a single linked record cell so that it is recognized as multiple linked records and not a new record with the concatenated name of all the pasted records?
I have two tables (Table 1 and Table 2) which are linked. Table 1 has a column which can link to multiple records in Table 2. I have a separate Excel document which lists the associations between records in Table 1 and Table 2 and am trying to determine how to paste these into Airtable to document the links between the records.
For example, Table 1 has the following records:
Table 2 has:
My excel sheet has the following pairs
1 - A
1 - C
2 - A
2 - B
2 - E
3 - D
In this case, I am trying to copy record “2”'s associations (A,B,E) and paste them into the single linked cell in Airtable to link those records between the two tables. When I copy A,B,E in their individual rows in Excel and past them into the Airtable “2” linked record cell in Table 1, it pastes A, B, E in separate rows instead of “A, B, E” and links the wrong records in Table 1. If in Excel I add A, B, E in to a single row, comma separated, and copy it, when I paste it into the 2’s Linked Record cell in Table 1, it creates a new record in Table 2 called “A, B, E”.
How can I paste multiple records into a single linked record cell so that it is recognized as multiple linked records? Thank you!