I’m a little new to airtables but have found it amazingly powerful so far and very simple. However, I’m trying to find a way to automate a accountability process which I am struggling with where to start.
Right now, I have a main schedule assigned to staff and tasks between two-date times, and a calculated duration for the hours of work.
Then I have the contractor billing input where contractors tell me which clients they have worked with and the start datetime and duration.
Basically, I want to cross reference to see whether the main schedule adds up with the report that contractors are inputing. I want to cross reference the number of hours, and whether they are completing their assigned tasks. So matching a task and a staff from the schedule with the timesheet input.
Any means of doing this? Where should I start?