Jan 22, 2021 03:42 PM
Hi there, :wave:
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 :pray:
Solved! Go to Solution.
Jan 23, 2021 08:50 AM
Hi Dorian,
Create new automation Trigger “When a record is Created” and choose in TABLE B
Create 2 actions the first is “Find Records” and choose in TABLE A condition where “Name” contains “Record(Steup1:Trigger) … Name”
Hope this does it, best of Luck
Jan 23, 2021 08:50 AM
Hi Dorian,
Create new automation Trigger “When a record is Created” and choose in TABLE B
Create 2 actions the first is “Find Records” and choose in TABLE A condition where “Name” contains “Record(Steup1:Trigger) … Name”
Hope this does it, best of Luck
Jan 25, 2021 01:34 PM
Hi Hossam !
Thanks a lot, it works perfectly !! Huge thanks again :pray:
Jan 25, 2021 11:32 PM
Hi Dorian,
You are more than welcomed.
Best Regards :slightly_smiling_face: