I have a linked record field in my table (Table A) where I disallowed the linking with multiple records from Table B. However, when I duplicate a record in Table B that is linked to a record in Table A, the linked record field in Table A gets 2 linked record, even though the linking with multiple records is still disallowed. How can I prevent this to happen?
Solved
Multiple records linked to a 'linked record' field, even when it's disallowed in the field option
+4Best answer by ScottWorld
Unfortunately, there is no way to prevent that from happening. Unfortunately, the “restriction” that you set on Table A is not really a restriction… it is simply a tiny little cosmetic obstacle to make it a little bit more difficult for a user who has access to Table A to add more than one linked record.
But ALL other parts of Airtable can bypass this restriction: automations can bypass it, the API can bypass it, the linked table can bypass it, etc.
As a workaround, you could make an interface where users ONLY have access to Table A with no access to Table B. That would be a cosmetic way of working around the problem.
+35Unfortunately, there is no way to prevent that from happening. Unfortunately, the “restriction” that you set on Table A is not really a restriction… it is simply a tiny little cosmetic obstacle to make it a little bit more difficult for a user who has access to Table A to add more than one linked record.
But ALL other parts of Airtable can bypass this restriction: automations can bypass it, the API can bypass it, the linked table can bypass it, etc.
As a workaround, you could make an interface where users ONLY have access to Table A with no access to Table B. That would be a cosmetic way of working around the problem.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.