Hi @TANC ,
Do you want to auto populate TimeIn column when edit this record and auto populate TimeOut column when end of editing(and save it)?
If yes, I would suggest you use Text column to keep the time. I did a simple test on my side for reference:
1. This is my list called “TimeList” with three Text columns called “TimeIn”, “TimeOut” and “TotalTime”:
This is my gallery(I add a label to keep ThisItem.TotalTime):
2. With the default app template, when click the arrow button next each record, it will go to the DetailedScreen. So go to the DetailedScreen, add “Set(VarTimeIn,Now())” function into the OnSelect property of the pencil/edit button, so that when you edit an item, it will save current time into this variable.
3. Go to edit screen, set the TimeIn control to the variable just created:
4. This time, we should keep the current time into TimeOut column when submitting changes, so set OnSelect property of save button to below(use title to lookup this record, and change its TimeOut column to Now(), also calculate time difference and keep the value into its TotalTime column):
SubmitForm(EditForm1);Patch(TimeList,LookUp(TimeList,Title=DataCardValue5.Text),{TimeOut:Now(),TotalTime:DateDiff(DateTimeValue(DataCardValue6.Text),Now(),Seconds)})
For test purpose, I use Seconds inside DateDiff(). On your side, the code should be:
SubmitForm(EditForm1);Patch(TimeList,LookUp(TimeList,Title=DataCardValue5.Text),{TimeOut:Now(),TotalTime:DateDiff(DateTimeValue(DataCardValue6.Text),Now(),Minutes)})
This time, when you edit a record, it will auto populate with the edit time and when you save your changes, it will auto populate the exit time.
Best Regards,
Allen
