Help

Applicant Tracking System (ATS) One applicant, multiple roles

Topic Labels: Base design
1136 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Michelle_Goh
4 - Data Explorer
4 - Data Explorer

Hi - we’re trying to develop an Applicant Tracking System for our applicants. However most of them usually apply to multiple roles. The basic ATS template now - only works best if they apply for one role.

We would like to track easily - which roles they have applied for, and the feedback that they have gotten for each of the different roles. And when I click on a role, I want to see who has applied, and the feedback for that specific role.

Is there a good way to structure our database?

The only way I can think of is to have each job as a different tab - which will not work, because we have quite a lot of roles…

Thank you so much :slightly_smiling_face:

1 Reply 1

Welcome to the community, @Michelle_Goh!

Sounds like you will need to setup your database as either a one-to-many relationship or a many-to-many relationship.

However, it sounds like a many-to-many relationship might be your best long-term option.

Both of these types of setups are described in this article:

p.s. If you have a budget for this project and you’d like to hire an expert Airtable consultant to help you design & setup your Airtable system, feel free to contact me through my website at ScottWorld.com.