Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 26, 2019 11:26 AM
This is probably a bug? But copy pasting a value into a linked record is not working for me. It used to work before… It says “Pasting…” but then doesn’t do anything… HELP!
Apr 26, 2019 01:54 PM
I’ve just tried this and it works for me, although it does take a second or two. I’m guessing it is validating the pasted data in the background to check if it already exists or not (and as you probably know, if it doesn’t exist in the linked table it will create it there) so there’s clearly a few things going on when you paste data. But if you’re not getting it completing the action, feels like it might be more of a network error/timeout perhaps.
JB
Apr 29, 2019 03:01 PM
Yeah I think it was because the primary field in the table that was being referenced was a formula field therefore it made sense copy pasting didn’t work, for the benefit of others
Jun 17, 2019 08:34 AM
There is actually a glitch here, I’ve tried contacting Airtable about it to no avail. If you copy a data set with multiple linked fields into a new linked table a lot of the links are simply lost, or never created. Pretty strange.
Oct 21, 2020 08:16 PM
I am also experiencing this issue! Anyone come up with an answer? It used to work, just stopped working over the last few months. Thanks!
Dec 15, 2020 01:03 PM
+1 for this issue. I’m having this trouble with specifically linked columns but not others in the same table. Any progress?
Dec 15, 2020 01:04 PM
Did you find a solution? Same issue here with a few linked columns in a table where others are working. So odd and annoying. :slightly_smiling_face:
Feb 04, 2021 03:05 AM
I was having this problem and I think I’ve found a solution:
It seems like the issue arises when there is a white space after the term you are trying to copy and paste:
“Value”
vs
"Value "
I have had issues with whitespaces before and found when I added quotation marks to my list of values, all the values that weren’t pasting had a white space at the end. Thus when you try to paste the value, the lookup field is only reading to the end of the string (the ‘e’ at the end of “Value”) and so doesn’t recognise the value and remains blank.
My list was 1000+ values long so removing all the whitespaces wasn’t very efficient. As an alternative solution I used a bit of code to add quotation marks to the values and then tried copy and paste again and it worked:
CONCATENATE(’"’,{Field Name},’"’)
(That’s a single quotation, double quotation, single quotation on either side)
That should encapsulate your list of values in double quotations. Now when you copy and past the linked field also reads the white space and matches the term.