I am try to create an online check-in/out tool on SharePoint via using Nintex Form, the purpose is simple, once the item is created, I can use the *created* time as this person's Check-in Time.
At the end of the day, this person will back to the same list, and open the item he/she created this morning, click on Save, then the last modify time can be used as this person's Check-out time. However, the problem is if this open come back to open the item to save again, the last modify time will get updated, the record will mess up....
does anyone know any better idea to auto-record the first modify time (check-out time), but not allow anyone to edit the time again.
I used try to add a *Date/time* on my form (enable on edit mode only) as the setting below, but I found two problem, 1. the time will be updated on every save 2. the time didn't be recorded precisely, e.g. 7:05pm will be record 8:00pm
Solved! Go to Solution.
What you could do :
- create a speicfic SharePoint column, for example "First checkout"
You can't use the native "Created" or "Modified" columns, as they are managed by SharePoint.
I would use a list workflow and trigger it on item creation to update timestamp your item. This keeps the update more manageable and allows for future expansion. If there is a need to add more functionality, you have a place for it already. I try to avoid code in my forms, but it is an option.
Hope this helps!
Hello Jesse and Hunth,
It works perfectly! Thanks a lot!
one more question, do you happen to know how to calculate the total hour + mins by using current data I have collected?