+1Best answer by TheTimeSavingCo
You should be able to paste into a linked field fine, and Airtable will either automatically link to records in that other table or create new records there. Note that Airtable treats strings as a comma separated list, so if you paste in "1, 2, 3", Airtable treats that as 3 records, not 1
If you're pasting into a linked field and nothing is happening, possible explanations could be:
1. The primary field in the linked table is a formula field
2. You do not have permissions to create new records in the other table
If neither of the above help, could you provide screenshots of the tables and fields in question, as well as an example of the data you're pasting in?
+31You should be able to paste into a linked field fine, and Airtable will either automatically link to records in that other table or create new records there. Note that Airtable treats strings as a comma separated list, so if you paste in "1, 2, 3", Airtable treats that as 3 records, not 1
If you're pasting into a linked field and nothing is happening, possible explanations could be:
1. The primary field in the linked table is a formula field
2. You do not have permissions to create new records in the other table
If neither of the above help, could you provide screenshots of the tables and fields in question, as well as an example of the data you're pasting in?
+1You should be able to paste into a linked field fine, and Airtable will either automatically link to records in that other table or create new records there. Note that Airtable treats strings as a comma separated list, so if you paste in "1, 2, 3", Airtable treats that as 3 records, not 1
If you're pasting into a linked field and nothing is happening, possible explanations could be:
1. The primary field in the linked table is a formula field
2. You do not have permissions to create new records in the other table
If neither of the above help, could you provide screenshots of the tables and fields in question, as well as an example of the data you're pasting in?
Thank you, Yes I believe it's because my primary field is a concatenate formula' Is there a workaround?
+31Thank you, Yes I believe it's because my primary field is a concatenate formula' Is there a workaround?
Hmm...you could try to use an automation for this? If you're only creating one record in the other table for each record in your main table, that'd be simple enough: have an automation that triggers when X field is not empty and the linked field to the other field is empty, and its action would be to create a record in that other table and link it back to the triggering record
If you're creating multiple records, you could try creating a multiple select field and pasting your values into that. You'd then have an automation similar to the one above, except you'd add a repeating group into it and use the multiple select field as a list and create one record per multiple select option
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.