Hi! I am trying to create an option to clock in and out for individual events. What I have so far is it is adding a row to my timesheet data table, when I press clock in it is working for that individual event. When I clock out though it is overriding and taking the clock in time away. It is putting it in the same row now which was previously an issue. What do I need to do?
What you need to do is fix it 
What action are you using with Clock Out?
Depending on how you’ve set things up, you should be using either an Edit Screen, or a Custom Form with a Set Column Values action on submit.
If you can show us some screenshots of what you have, there is a better than average chance that we can point out what is wrong and what needs to be fixed.
1 Like
Okay, first thing - both your Clock In and Clock Out columns are User Specific:
You almost certainly don’t want this, unless you intend all users to be adding data to the same row. And I’m pretty sure that’s not the case. So you should delete those and add them back as non-user specific columns.
You haven’t shown what the action is on your Clock Out button, but this is what I would suggest:
- Create a Query column that targets your Timesheet table, and apply the following filters:
– User Email is signed in user
– Clock In is not empty
– Clock Out is empty - Make sure you do not check the “Match multiple” box
- Then the action on your Clock Out button can be Set Column Values that targets the Clock Out column via the above Query, setting the current date/time
2 Likes
Hi! Its still not working would I be able to maybe send a video? I am not really sure how to fix it with this many options
Sure, please do.