Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 22, 2021 01:00 PM
I want to paste a string of text into a linked cell and have it recognize the linked relationship. I have about 2,000 lines of data to copy and paste into Airtable.
For example, I want to copy the following addresses into cells where the cells link to another table.
123 Main Street, Anywhere, CA, 90210
578 Main Street, Anywhere, CA, 90215
I have not had any luck in pasting it or in the cells recognizing the link. I have also tried “wrapping” the text string in commas as follows:
“123 Main Street, Anywhere, CA, 90210”
“578 Main Street, Anywhere, CA, 90215”
No luck with that method either.
Any suggestions?
Thanks
Feb 22, 2021 11:42 PM
I just tried copying and pasting into a linked field and I can successfully create the link. Can you share the schema of your linked tables. Also what happens when you paste. Do you see any error? Does the text get pasted at all?
Feb 23, 2021 08:19 AM
It doesn’t give me an error message, it actually looks like its attempting to paste the data. And, it actually creates additional records to make room for the pasted data. However, the results are blank.
Did you wrap it in quotation marks? Maybe I have too many commas in the data string?
Feb 23, 2021 08:34 AM
Not sure if this plays into it, but the “Property Address” field in the table I’m trying to link to is actually a formula.
Feb 23, 2021 09:21 AM
Is the {Property Address}
field the primary field? Even if it’s a formula, it should work, but it needs to be the primary field, and the spelling, capitalization, spacing, etc. of what you’re pasting will need to be an exact match for the formula’s output. If it’s not an exact match, it will make a new record, but that primary field will be blank because the formula will be pulling from empty fields (or defaulting to null output, depending on your formula design).
Feb 23, 2021 11:14 AM
Yes, {Property Address } is the primary field. And, what I’m trying to paste into the cells are perfect matches of the linked cells (text, commas, spacing…everything).
Feb 23, 2021 11:42 AM
I think this issue, is in fact, related to the formula.
Aug 04, 2024 08:47 PM
Did you find a solution?
I'm facing the same issues