I’m hoping someone could help me out there with an automation issue. So here it is :
I’m recruting people. So I manually create a new record in a TABLE A. This record contains several information : email, name, contact date… I’ve also created a “single select field” called “Document received ?”. The choice is between YES or NO.
An Airtable form is sent to the candidate. It helps me gathering datas such as : ID Card, Licence driving, email, phone number, etc… Then, the form appears in a view : in a TABLE B.
Here is the problem : When a new form is received in TABLE B, I want to automatically update the record that matches the name (or the email) of the candidate in TABLE A. So I want the field “Document received ?” to automatically turn “YES”.
PS : I’ve created a “LINK TO” field in table A and an automation that works. BUT I have to manually update the field before the automation runs. Otherwise I receive an email that alerts me about an automation error.
Do you have any ideas about how I can solve this problem ?
Thanks a lot