I have an automation, where the automation should copy a field whenever a new record is created. It should copy the data from Instance field to All Events field in the same table. However I get an error that says “Updating the record failed due to insufficient permissions.”. I made this automation as the owner of the base and I have absolutely no idea what or where is going wrong.
Does anyone have any recommendations to solve this problem?
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.
