The field that you are trying to update it’s a link to another table?

Hi,


I have the same problem and yes it’s when I’m trying to update a link to another table. Do you know what is the problem ?

Yes it is a lined field. But changed a bit the schema and now it is working.

How did you do that? :winking_face: I’m trying to update a link field as well, using automations.


I encountered the same error message: “Creating the record failed due to insufficient permissions.”

Thank you!! Be well,

I reversed the flow. I have 3 tables that play a role here. I have ‘Instance’ ‘Proposal’ and ‘All Events’. First The automation is living in ‘Proposal’. I wanted the automation to copy and paste the linked ‘Instance’ whenever a new Proposal occurs, in the same table, to ‘All Events’ field. It gave me back the same error. But I changed it, and made it like the following: When a new proposal is entered, do not make this automation in the same table, but go to ‘All Events’ and paste the Instance there. This way all of the 3 tables are connected. In my opinion, both methods should work so I guess this is sort of a bug.

If I understand well, you link the record not from its table but from the linked table… So you must find the correct record in the linked table. I will try and see how it works.

One thing it took me far too long to spot was that the Field permissions of the field I was trying to update were wrong! Check that first folks.

Hi Community,

I have automation running that needs to update linked record once record is created.


Automation has condition. The first condition checks the name of one field and then updates the linked record. The second condition checks the same field but with different name and it should update the linked record.


The strange part here is that it works with the first condition but not with the second. So let’s say it works if I want to update linked record with text A but not if I want to put text B. I think that is a bug and not something with my automation. The error in automation suggest issue with permissions but that is not the case because it updates the filed if the update text is different.

Could you help with this?

This was driving me crazy when I tried adding all the fields I wanted individually. Then I decided to try adding just "Airtable Record ID" and it actually worked.

For me, the record it was trying to update was a drop down, single select that was synced from another base. The issue was that the option it was trying to update to was not an option in the drop down select and the automation didn't have permission to add the new option. I am ok with this as I don't want new options available via this method and it let me know someone tried to create one without permissions.

My problem is that the linked record contains leading or trailing spaces. When I run the automation, it shows an error: "Updating the record failed due to insufficient permissions."

To solve this problem, I trimmed the text of the field to remove the extra spaces at the beginning and end of the value.

Thank you, this was it for me!

Also, ensure your table permissions allow records to be created via automations.