Applicant Tracking System (ATS) One applicant, multiple roles

[Michelle_Goh]

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:

[ScottWorld]

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:

Airtable Support

Airtable's guide to many-to-many relationships

What sets Airtable apart from ordinary spreadsheet applications is its ability to link related concepts together. Knowing how to represent the relationships between different groups of objects can ...

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.