Hello everyone,
I’ve created an Airtable to help manage pre-production workflows and am struggling to get what I think is a simple automation running;
I’d like that when a record is assigned a contact person (The “Assigned?” field is “Yes”) and given an “Assignee” to carry out this task, that the status of that record be updated in the “Interviewees” table to “Contact Assigned.”
This is the automation I’ve set up so far but no matter what I do, I keep getting the “Record does not exist” error.
I can’t get it to update the status of the record within the “Interviewees” table. Now I’m wondering the problem lies in the fact that the record name or interviewee name is not the primary field in the ‘Interviewee contact status” table, but you can’t make a primary field a linked record. Is there any way to get around that or is that not the problem at all?
Is this an automation problem or a table infrastructure problem? Thank you!
