I have a question about using Airtable to manage the creative team workload over time.
My goal is to build an Airtable template and ask the team members to write down the number of hours they spent on every task on a daily or weekly basis. And keep these records in the Airtable.
This could help us to keep track of the busy weeks and days that are less packed.
E.g., my producer can put down 2 hours today working on a video shoot task for planning, and 8 hours tomorrow on this video task again for onsite shooting, then 5 hours the day after tomorrow for this video shoot task for post-editing.
As you can see, I need a series of fields, that are connected with consecutive dates, and to be filled with numbers, which are the working hours.
I can then calculate the total hours they spent on a task easily with a formula. But I’m having difficulty building this template.
Does anyone know how to achieve that with the Airtable?
I’m open to any suggestions from using a template to an extension.
Many thanks in advance!