cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

how to auto-record the first modify time, and don't get it updated on the next open

Jump to solution

Hi,

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

Thanks,
Zoe

Labels: (3)
Tags (2)
Reply
5 Replies
Highlighted
Nintex Newbie

Re: how to auto-record the first modify time, and don't get it updated on the next open

Jump to solution

What you could do :

- create a speicfic SharePoint column, for example "First checkout"

- on Form saving, do something like "if and only if FirstCheckout is empty, copy Modified date in it" with javascript

You can't use the native "Created" or "Modified" columns, as they are managed by SharePoint.

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: how to auto-record the first modify time, and don't get it updated on the next open

Jump to solution

Create a workflow to start on creation and then update a SharePoint column named firstDateTime

Reply
Highlighted
Nintex Employee
Nintex Employee

Re: how to auto-record the first modify time, and don't get it updated on the next open

Jump to solution

Hello -

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!

View solution in original post

Reply
Highlighted
Nintex Newbie

Re: how to auto-record the first modify time, and don't get it updated on the next open

Jump to solution

hi Thomas,

I have created a column on SharePoint named "Check Out Time", but I don't know where I should do the setting for the second step you mentioned "on Form saving, do something like "if and only if FirstCheckout is empty, copy Modified date in it" with javascript'', can you share more information with me? thanks!

Zoe

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: how to auto-record the first modify time, and don't get it updated on the next open

Jump to solution

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?

thanks!

Zoe

Reply