I’m having this issue when trying to create a record into another table within an automation.
I have creator permission in both tables and a paid plan.
I’ve tried everything on this link Error in Automations
and i’m now figuring out if that last comment is what is happening to me, though that would mean i cant create records if im leaving lookup or linked record field empty.
In that case, Is there any way of doing both of them?
Hello and welcome @ardilla_4!
Could you give a little more information about the automation you are trying to create? What is the trigger, and what actions are involved?
For context, the error you are receiving can happen when the cell value for the linked record is not a valid primary cell value for the linked table (e.g. if the primary column in the linked table is a computed field).
If you’re working with a computed primary field, you could add a Create Record action prior to your Update Record action in the Automation, then point the Update Record action to the record from the Create Record action’s output. Note this will always create a new record, for example, even if the record you’re linking to already exists.
Let me know if that helps, or if not- I’d love to help more once I understand your automation a little bit better.
Hi Rose, I’ve just started with Airtable and I have found very limiting the Link field, I have the same issue reported by “ardilla_4”, I’m getting: “Updating the record failed due to insufficient permissions.”
My “calendar” table is where all the calculations are done and includes 8 different destinations fields (Dest1, Dest2, etc), I linked them to my table “currencies” where primary field is the airport code, the lookup field on calendar table looks for the currency on currencies table. The automation works for the first destination (Dest1) but not for the rest.
Dest1: IAD (Washington), Dest2: IAH (Houston), Dest3: FCO (Rome)
Currency1: USD (Washington), Currency2: USD (Houston), Currency3: EUR (Rome)
I didn’t get the solution that you suggested on your previous post about Create Record action prior to your Update Record action, could you please show an example?
Thanks for your help
I’d love to help try and figure out what is causing the error in your automation workflow! It’s bizarre that the first run of automation is working, and the rest aren’t:
This makes me think the automation’s “Update record” step is the one causing the problem. At this point I think I might need to see your Automation’s run history to really get to the bottom of things.
Could you please share a quick a 1-2min screen recording, or screenshots, walking through the Automation workflow and run history (especially the record throwing the error) so I can speed up the troubleshooting process? If you aren’t comfortable sharing feel free to DM me directly, or contact customer support via chat here.
Hi Rose, thanks for your response, I have turned to code in order to bypass the issue so I have deactivated the automation.
The problem with the automation is basically is as you have mentioned on your previous post I can’t use the link field in this case, in my main table I have 7 columns (Dest 1, Dest 2….Dest 7) link to the city in my other table to the get the corresponding local currency for each destination and as I have mentioned on the post I was getting the automation failure.
Thanks again for your quick response and I hope I don’t find more issues with link tables.