Skip to main content
Nintex Community Menu Bar

Timestamp Functionality

  • July 11, 2019
  • 2 replies
  • 15 views

Forum|alt.badge.img+3

I have a simple form. There is a drop down that contains 2 values - New (default) and Assigned. I have a workflow that records when the value is changed to Assigned and a report that captures when a form is created and that timestamp. 

 

My question is if a user creates the form and ALSO changes the value to Assigned the timestamp shows that the value was changed 1 second before the form was created. This is throwing off the report. Is there any way around this? 


If there is no way around this, does anyone have an idea how I can modify the excel formula to not error out.... :smileylol:

2 replies

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • July 12, 2019
Hi,
This is a little tricky. I think the best solution is to make it so that the user cannot set the drop down to assigned in new mode. They would have to submit and then go back in and set to assigned.

Forum|alt.badge.img+14
  • Scholar
  • July 17, 2019

how exactly do you capture "the timestamp" for assigned state?

 

you could make a condition in the workflow - if "the timestamp" is less then created time then save created time, otherwise "the timestemp".

 

... or you could make a conditional formula in excel report