Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 04, 2021 04:25 AM
Hello!
I’m trying to create an automation on Zapier or Airtable:
Table 1 View 1 : All my Candidate Onboarded
Table 2 View 3 : Job description Published
I’d like to create an automation when a job description is published (table 2), send an email to the candidate who matches with “Expertise 1” or “Expertise 2” or “Expertise 3” of the Job description (table 2) is the same as “Expertise 1”(main expertise) or “Expertise 2” or “Expertise 3” of the candidate (table 1).
Thanks
Solved! Go to Solution.
Oct 06, 2021 05:43 AM
Hi @Anthony_Berthon ,
ok so you most probably have one table=“Job description” and this is where a Project Owner stores information for job descriptions.
You also have a second one with the name “Candidates profiles” where you store all the given by candidate information.
Then you want match candidates with job descriptions based on the “expertise” field which is common in both cases, right?
To do this you have to create a “linked to” field in “Job description” tab. This field will be linked to the “Candidates tab” and in this you can request the “Expertises” from there. On this filed you can run lookup to return the candindate’s name.
Please check the solution text us back for the results. :slightly_smiling_face:
Oct 04, 2021 11:15 PM
Ηι @Emma ,
welcome to Airtable community!
First of all you have to link the tables with each other. Then you can create the automation in Airtable with no using Zapier. You will set up the trigger in the table where you make the update.
For any further help please don’t hesitate to post in community.
Thanks :slightly_smiling_face:
Oct 05, 2021 03:25 AM
I have 3 tables :
-Candidate
-Job
-Expertise (all with link to record)
each candidate profile has 3 expertise completed maximum
each job description has 3 expertises completed maximum
In my example, i’d like that Job A would be send to Candidate X, Y & W
Job B to candidate Z…
how can I :
Thanks
Oct 05, 2021 01:16 PM
Hi @Emma ,
this is not a common Airtable table, so I can’t think a solution for you. Do you have the same case in Airtable tables?
The big difference is that you have put a 2 dimension tables while in Airtable we use column based tables…
A screenshot with fake data would be great :slightly_smiling_face:
Oct 06, 2021 12:42 AM
The idea is just to match “EXPERTISES” from a Job Description published by a Project Owner with “EXPERTISES” of Candidates Profiles from our database.
Then send an automatic email to relevant candidates when there is a match on EXPERTISE.
Thks :slightly_smiling_face:
Oct 06, 2021 05:43 AM
Hi @Anthony_Berthon ,
ok so you most probably have one table=“Job description” and this is where a Project Owner stores information for job descriptions.
You also have a second one with the name “Candidates profiles” where you store all the given by candidate information.
Then you want match candidates with job descriptions based on the “expertise” field which is common in both cases, right?
To do this you have to create a “linked to” field in “Job description” tab. This field will be linked to the “Candidates tab” and in this you can request the “Expertises” from there. On this filed you can run lookup to return the candindate’s name.
Please check the solution text us back for the results. :slightly_smiling_face: