I’m working on a project for a HR agency. They have a list of people looking for a job or currently employed. For each of them, they track their employment history as they change frequently positions and/or companies.
Listing these people in Airtable is straightforward, consider this part done.
But for the individual employment history, I have some doubts about how to tackle this.
For each past job, I must quote the start and end date, the company name & location, the salary rate, etc.
Now, they’re filling up an Excel sheets and adds new columns at the end of it when it’s necessary to add one more past job experience. The position currently occupied by the person is visible in the first columns and when it’s over, they copy/paste the job infos in columns somewhere near the end of their sheet.
In short, the sheet’s columns looks like this:
A: Reference (Concatenation of the first & last name)
B: First Name
C: Last Name
D: Current Position
E: Current Company
F: Start Date
G: End Date
W: Last Position
X: Last Company
Y: Last Start Date
Z: Last End Date
AW: Second-to-last Position
AX: Second-to-last Company
AY: Second-to-last Start Date
Of course, I won’t do that in Airtable but I’m not sure if storing the employment history in a linked table will be handy too (How to move the current position to the employment history when the person is done with the job?)
If any of you have an idea, I’m all ears