Time tracker Interface with Start and Stop Buttons

I think the problem is that the “Find Records” action of the “Stop Tracking” button automation returns an array, and you need to wrap the “Update Record” action with a “Repeating Group”

​@coderkid Could you explain further and/or share a solution for this automation? Thank you

Since search may return multiple records;

Update the records, inside the loop :
 

​@coderkid Awesome! This works, thank you.

Hey ​@Ben at SEG - I’ve got an internal ticketing system that does exactly this and ran into the same issue when initially setting it up. The way I got around it was to have our “Stop Tracking” button pop out to a new interface page where users could log notes about what they worked on, and then toggle the status on a “Start/Stop” single select field. 

Overview:

I have an interface that’s tied to a “Tickets” table. Once I pick which ticket to work on, I can click a green “Start Tracking” button that triggers an automation. The automation creates a record in a separate “Time Tracking” table and updates a single select ‘Start/Stop’ field to say “Started.” It also automatically links the time tracking record to the Airtable Record ID from the Tickets table. (It also runs an Update Record automation to change the ticket status to “In Progress”.)

When I’m done working on a ticket, I click a red “Stop Tracking” button in the same interface, and it takes me to a new “Time Tracking” Interface. This interface uses the Time Tracking table as the source. I jot down notes documenting what I worked on, and then I toggle the Start/Stop single select field to “Stopped.” 

In the time tracking table, I have a “Start Time” field which is simply a Created Time field tracking when the record was created. I also have an “End Time” field which is a Last Modified Time field tracking when the Start/Stop field is updated (i.e. when I switch it to “stopped”). Finally, there is a formula field calculating the difference to show the total time logged. To keep track of multiple punch-ins/outs against a single ticket, I have a Roll-up field calculating the sum of all punch-ins logged to that record. 

Below are some screenshots, but I’m also happy to hop on a quick call sometime and walk through how the system works if that would be helpful. 

I know this is a lot, but let me know if you have any questions. Thanks!