Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Matching jobs and candidates

Topic Labels: Formulas
907 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello everyone,
I am looking to create a formula to match candidates and job openings.
Each “job” & “candidate” have hard & soft skills wich are tags (found each in separate tables)in our base.
The goal is to create a function helping us find which candidates have the most tags (skills) in common with the tags found in the job descriptions.
Would love some help from the community.

4 Replies 4

Another way to look at this could be having your jobs and candidates listed in the same column. Then use the grouping feature to lump records that share the same tags.

So if “Mac” has the tags x, y, z and Job 1 has the tags x, y, z if you group by the tag field, then Mac and Job 1 will be grouped together.

Hey Mac,
Thx for the help.
If I understand this well, there is a shortcoming to this as Mac might have a skill “a” which is not in Job 1, thus the grouping will not show Mac and Job 1 in the same group.
Do you see what I mean?

Pierre, did you find a solution to this? I am looking for something similar. thanks

I’m also looking for something similar. We have candidates being submitted with skill sets and need to match them to roles that are open (each in a different base) and can’t figure out how to link them.