Clock In/Clock Out app

Hey Simon,
I’d be glad to help.

First off I found this thread very helpful while I was building out he structure. The user hanan1’s replies answered most of my questions.

For my Data structure I have 3 Data Types, Users, Projects, and Timesheets.

The Timesheets Type has fields User, Clock In Time, Clock Out Time, Project, and Total Hours

For the Workflows I have this for the Clock in Button.
Step 1: Create a new thing, Type Timesheets

Step 2: Make changes to a thing. Current User Clock In Flag. (this is so i can display a message like "You are currently Clocked In/Out)
Screenshot 2023-04-27 at 3.38.06 PM

Step 3: Display Data

Then for the Clock Out button.
Step 1: Make changes to a thing

Step 2: Make changes to a thing (this has to be a separate step)
Thing to change: Parent group’s Timesheets
Total Hours = This Timesheets’s Clock Out Time:rounded down to minute - This Timesheets’s Clock In Time:format as hours

For the groups that the buttons are in you need to set Type of content to Timesheets, and Data source to Search for Timesheetss:last item
Screenshot 2023-04-27 at 3.46.56 PM

Then it should have all of the data in the same row and calculate the total hours.

Hope that helps!
-Alex

1 Like