I needed to extract the current time in Nintex Forms. I am aware of the CurrentTime nintex function, but the problem is that the currentTime is never updated and if the form is kept open for a few minutes the time is not updated. I believe Nintex loads the variables when the form is first loaded. I need to get the exact time (don't want to use the client time and would need to rely more on the server time).
Any guesses how I can achieve this.? I have tried a number of ways like calling a processupdate() function to refresh my calculated field to give the current time, but the time never refreshes and it always stays the same (i.e. the time when the form first loaded)
has anyone else faced this and how did they overcome? Any suggestions welcome.
what about to use OOTB sharepoint field 'Created'?
or you can create your own datetime list field and set it's default value to current date. if you do not supply it's value from forms it will be populated with date&time when item is created.
Date is not an issue, its the "time" that's an issue. When the form is first opened the time is set and after that the time is never updated. So if the user closes the form (using a button click) and if I read the "time" at that moment the time would be past(may be couple of minutes behind depending on how much time the form is kept open). I need the exact time the user had clicked the button.
No ... not the update datetime field.. Cant use the SP OOB LastModified or Created Date
User opens my form .. reviews stuff, puts in comments and Submits the form. (Submit is triggered through a button click).
I need to add the datetime stamp on the user comment fields and save it.
For adding the dateTime stamp I am using Nintex inbuilt function CurrentDate and CurrentTime. This issue with using CurrentTime is that it is not realtime and if the user has taken few minutes to review before hitting submit the Time that I add to the comments is few minutes earlier. Is there any way to get the "Server" currentTime on the nintex Form ? (realtime)
I am already using appendChanges for some other text boxes. The problem with AppendOnly is it uses versioning behind the scenes to save data and its difficult to extract the entire text out of the appendonly field.
Try adding the appendonly text box to your default view and see the contents. It doesnt show up.