I'm stuck here and need aid from the community.
I have three text fields: StartTime, EndTime, and TotalTimeSpend.
I'm referring to form as form1.
When I select the status field as Production, Break, or any entry, I want the Starttime to take the current date and time, and when I submitform(form1), it should get the End date and time, as well as the total time spent in HH:MM:SS:
Endtime = DataCardValue6
Data is storing in Sharepoint List name TimeTracker.
I mean to say here is when i Select any entry from the dropdown (production, break, end, etc) The StartTime need to be saved and then when i click the save button then only Endtime capture the current date and time and form can be reset
Not getting the App work. What need to be done here. Any changes in SP list you suggest to do to get the end result
I've not forgotten you!!
Can you describe the logic you have for these entries? You seem to indicate that each record will record one particular status with a start and end time. Is Start time supposed to be determined when the form is open and end time when it is saved? Or is there something else?
Nope it's not that. I have used flow to tigger that starttime and endtime.
But now I tried to implement your video of timestamp which you have posted in YouTube. I tried to implement the same logic in new screen. With when new user come and press button the time stamp that and when end it captures the end time but the condition would be like . If it's less than 9:30 hrs then it should give a message as it's less than 9:30 hours and wants reason for early logout in some text field and then submit