Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Tracking time without time tracking app or scripts

665 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Here is my solution for tracking time in my job.
Scenario - I’m an owner/field service technician. I use Airtable 90% of the time on an iPhone or iPad and need a way to track time per job and/or the same job with multiple visits.

Obstacles - Airtable mobile app for IOS cannot run apps or scripts.

Solution -

Screen Shot 2021-03-07 at 9.50.10 AM

  1. Two check boxes (START JOB & STOP JOB) to trigger two ‘last modified’ columns(Start Time & Stop Time).
    58024AD2-F467-465B-B2FA-5A40EA13B5CD
  2. Then a datetime_diff formula in TIME(MINS) to calculate the onsite job time in minutes. - DATETIME_DIFF({Stop Time},{Start Time},‘m’)
  3. There is an Automation for every time the STOP JOB is checked. It creates a new record in the TIME table and links it back to the original TASK #(job).
    7E124646-5914-41E1-ABC7-48B3EB242721
    E9F8454F-A252-4C0B-BFAE-B4D3F06F9806
  4. Back on the TASKS table, I have TOTAL TIME rollup the sum of all the minutes.
  5. Finally the calculation of hours and minutes is completed in the TASK #, but only if the STOP JOB is checked.
    Screen Shot 2021-03-07 at 10.40.49 AM
2 Replies 2

That is quite the clever setup! Thanks for sharing it! :thumbs_up:

Thanks

Thank You,

Dan Burke
The Fitness Repair Company
704-517-3963