Skip to main content

Hi,

I have an automation that is triggered when a record is created in Table X, and it then creates a new record in Table Y. This automation has been working well, but recently, I've noticed some failures in the Run History.

It's not happening with all cases—only some. The trigger and all other actions work fine; the only issue is with the creation of the new record. The error shown is: “Creating the record failed due to insufficient permissions.”

However, when I take the same record that triggered the automation and run a manual test using it, everything works perfectly and the record is created successfully.

This is quite confusing—I don’t understand why some records fail while others don’t, and why it works without issues during manual test runs.

Could you please help me troubleshoot this?

This might be an intermitent issue. You can reach out to AIrtable Support for more help.

Taha, Airtable Advisor

Hmm, are you pasting data into a linked field as part of that Create Record action?  If so, if that table’s primary field is a formula field then you might hit this error if the pasted value doesn’t already exist there

Hey ​@paulac998 is this still happening?

Expanding on Taha’s answer above, you would want to email support@airtable.com

If this is still happening, please feel free to reach out and we can try to figure it out together on a brief call. Happy to help out.

Mike, Consultant @ Automatic Nation

Hi,
Sometimes, when you put values in some type of fields, it require additional operations, which are made on the fly in manual mode. Like when you put value in linked field and that value absent in the linked table, it should auto-create new record there. Or, when you put new value to a single-select, it require schema updating including field options change, which is possible when you are Creator but can’t be done when you are Editor.
So you need to think from that side. Or, if it’s still not clear, share more info, at least expand ‘Fields’ under ‘Create record’ in error message and do a screenshot.
 

Absolutely agreed with ​@Alexey_Gusev answer.
Test and Closely check all the data, try to use different rows as automation input.

If you still has issues share information like scripts, with some screenshots.

Note: Make sure don’t share any api or token related information

Reply


Terms & Conditions