
Announcements
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!
Also, it is good to track the total of MS Team session status for "Available". No sure the session status information is accessible to PVA.