Hello! I'm creating a clock in system for employees. My data source is called "Time List" from SharePoint and I have the Columns Title, EmployeeID, Job (choices of job sites) , Date and Time, Location, Longitute, Latitidue, Punch In and Punch Out.
On the first page of the app, I only have job, and employeeID which are Data cards and the rest of the fields are hidden. The Punch In and Out date cards have a code for DefaultDate= Now(). They are shown in the picture just in case anyone has an idea on how to use them for my issue, but I will have those fields hidden as well. The fields hidden have a code for automatically updating the Date and Time, Longitude etc. Example: DateValue2 defualtdate=Now(). Hourvalue Default=Text(Hour(Now()),"00"), Title= User().Fullname
#1. I want to use a button to record the punch in and out times separately since I have the date and Time automatically updating.
#2. After submission. the user will be sent to a second page that displays all of the info that was sent. On the second page, I want to be able to calculate the total hours worked that day as well as for the week.
Thank You for any help given!

Report
All responses (
Answers (