Skip to main content

Creating duplicate record automation works everytime except for one specific record - receive Error

  • October 20, 2023
  • 1 reply
  • 16 views

Forum|alt.badge.img+4

I created a staff scheduler with a series of automations that copies a shift (Workday Date and Start/End Times, Location linked field, employee linked field, notes) to a future date based on 4 checkbox fields (creating a shift 1, 2, 3 and 4 days in the future).

While the tool works great, I started receiving an error with only ONE location linked field every time I try to copy a shift. The error reads as follows: 'Creating the record failed due to insufficient permissions.' I have tried several fixes, including creating a duplicate of the location in question in the parent table and cutting and pasting pertinent information and linking fields about that location into the new record. I am completely stumped and as it is impossible to reach Airtable directly anymore, I figured I'd turn to the forums.

Thanks in Advance!

 

1 reply

Alexey_Gusev
Forum|alt.badge.img+25

Hi,

check all linked fields (location, employee). It seems like you are trying to insert text value into linked field and it cannot find a match, so it tries to create new record there. Maybe the value contains comma or ampersand, so it breaks the single value into a list of parts/
Click to the arrow at the left of 'Failed to run', expand field values - usually that's enough to find a reason.