Timesheet Table

[egordin]

Hello!

I’m looking for some advice as to how to recreate some of the timesheet functionality that I currently get from Harvest within Airtable, considering my Airtable base has a lot of the data about our projects that I end up entering manually into Harvest.

Right now, our Harvest usage looks like this:

The records are “tagged” with the project, and the task that the time was spent on for that project.

I have the projects and tasks already in tables in my base, and the only way that I can see to set this up is like this.

Is this the only way to recreate the Harvest functionality in Airtable? What do you recommend I do differently?

[Mike_Heeney]

@Donald_Newlands,

Thanks! I’ve looked into On2Air and I’m going to sign up. Is there any way you could share your base template for this timesheet data transfer? My email is mike@lxdesigns.io if so. I’m collecting Airtable templates to streamline workflow for my software consulting company and would be happy to share anything I’ve put together if you have any remaining needs.

Best,
Mike

[Sophie_Armour1]

I’m sort of using airtable for time sheets. People fill in a form and the fields become name; date week commencing; project name 1; days on project 1; project name 2; days on project 2 etc.

I would like to analyse this data by project (how many days, by whom, which weeks) but am struggling to filter or view by project because each one appears in more than one field. Is there a way to make a ‘by project’ view from this?

Many thanks