If you copy text and paste it into a linked record field (C and V), either a link to an existing record will be created...
... or a new record will be created in the linked table to match the pasted-in text.
If you paste a text string containing one or more commas, Airtable will read those commas as separators, and create an appropriate number of links. If you wish to create a link to a record with a comma in its name, you will need to delimit the desired record name with double quotation marks. So, for example, if you copy the text string
Golden Grazeland, Bucolic Highlands, "Peoria, IL"
and paste it into a linked record field, it will create 3 links:
- Golden Grazeland
- Bucolic Highlands
- Peoria, IL
Note that If there are extra spaces before or after the pasted text, it will create a new record on the linked table (as opposed to linking to the record with the same name). Make sure to remove extra whitespace!