Have had this issue before, but haven’t really tried as hard as I just have to solve it.
I copy and paste in a list of names from a spreadsheet directly into a ‘link to another record column’ for contacts. This work awesomely to bring out a ton of information I can then export to another app in the right form.
What’s really wierd is I need to do this for a different set of data from a different source in a different table. I set them up the same way, but Airtable won’t let me paste the data straight into the “link to another record column” for contacts, it doesn’t matter whether I’m doing it from GSheets or Excel. HOWEVER, if I paste some of the names from the other sheet used above, it DOES work.
So, in summary, Airtable is letting me paste names directly into a “link to another record column” from one spreadsheet, but not from another. How can this be?