How to create a Breakdown in AT

Hi, everyone!

I am working on the creation of a Recruitment Tracker, I’ve added the columns that are going to be filled by my boss, however, that information needs to be broken down per participant.

For example, my boss would add that they need 5 salespeople. I need to find a way for it to show a record per position required (5 records in this case) with all the other information that was already submitted, but I’m not sure how to do it.

Have any of you encountered the same need / problem?

Thanks in advance!

Hi @Mariana_Rumualdo,
Welcome to Airtable. Sounds like you are in the right place. Yes, Airtable should be able to do what you need.

You will need at least two tables to complete this.

One table will have your Boss’s form and intake his results. Another table will have all of the recruitable people, their details and positions (this may need to be another table too), and the Form table should link to the people, then you can use look up fields to bring in their positions.

So you will use a combination of tables, views, linked records and look ups.

1 Like

Thank you for your answer! I’m dividing it by tables, but I assume the breakdown might need a script, right?

As far as I can tell from what you have written, I do not think you will need any scripts, maybe a formula for some calculations.

1 Like

Thank you @Vivid-Squid!

Feel free to post your work if you get stuck, I will do my best to help.

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.