Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 29, 2024 10:14 AM
I have a base that has all of our employees (~200) in a people tab. Every month our finance department sends me an updated Excel with everyone that months actuals in terms of employees. Given the number I would like to be able to CSV import this file and then be able to update the people, as well identify who is no longer on the list - and who is new to the list.
Additionally, it would be helpful to be able to use this information in the extensions/interfaces to show charts on the over month-to-month headcount change.
I think I will need to have some record indicator for each person that the records can align to but every idea I have had so far seems overly complicated.
Jan 29, 2024 11:43 AM
It's a tough problem to manage a changing list of employees in Airtable. Do you want to delete/add employees from the Employee table with each update?
As far as creating an interface, here's what I think I would do.
You can schedule time with me using this link.
Jan 30, 2024 01:01 PM
I think one solution that I have been trying to avoid is having a new tab for each month. Then the name record would be linked with the people tab. This seems like it would end up messy, visually at a minimum - unless someone knows a way to hide tabs.