Dec 09, 2021 12:15 PM
Hi!
I work at an Ad Agency and we use Airtable as a project management tool between all of our clients and creators. We specifically track each concept we are working on in a single row. We charge clients against a monthly hourly allotment of 30 hours per month. We are looking for an easier/ better way to track monthly hours per project per client.
Ideally, I want one column that can allow a designer to input their total hours per month as needed vs 12 different collums
Dec 10, 2021 02:12 PM
Hey there!
I would suggest doing these entries as records vs. columns in its own Hours table.
Use a Text field as the Primary field and input January, February, etc. as the records. (you could also use Date as the Primary if you want to get more granular)
Add a Single-select field and add the 2022 year to every record
Add a Numbers field for the Hours
Then create a linked record to the Projects table
You might also consider using January 2022, February 2022, etc in addition to having a Year field. Sometimes filtering and grouping can get confusing.