Getting the previous value of a list item after it was modified.

Dear , 

For Getting previous value of a "Title" as example, you can do the below:

1-Create a new column named "PreviouTitle"

2-In the Nintex Form, create a calculated value connected to "PreviousTitle"

3-Add this Formula to the calculated Value: Formula Builder

Where Title in red reference to the "Named Controls" Title in the form.

Cheers...

Hi Philip,

Thank you that really helps me a lot. But do you have any suggestion when I want to get the previous value of a Date&Time. Because I noticed that it cant be connected to the calculated value form control.

Also, Additional question after I apply those changes and when I start to edit it again the form seems to froze and I cant click any button on the window. it looks like this.

Concerning the Date, also there is no problem:

You need to create a column of type single line of text called "PreviousDate" and use the below formula in another calculated value as per the previous example for "Title":

Nintex Forms Designer - Empty - Item

Concerning the frozen form, it's not a related issue, If you need any help, send me the form as attachment.

Hi Philip,

I already attached the file please feel free to check it if your not that busy. Thank you!

Dear, 

1-I tried the form on my machine, it's working.

   Please try a system generated form and let me know the result.

2-Concerning "Getting the previous value", please let me know if the answer was correct and suits your needs.

Hi Philip,

I also tried it again and it worked. But sometimes it is unclickable maybe a 70% chance of working. How can I get a system generated form? do you mean the default one? Sorry for asking those questions because I am really new to the nintex form. Also regarding the previous value. should I just remove the formatDate if I want to get the data and time? because I checked the available formats for formatDate() and there is no date and time given.

Also I've got another question. Is there a way to create a calculated value in the list setting? because there is a calculated type in the columns but the formula only allows to insert a column and there is no Name Controls. Because when I am using the default generated form it work 100% all the time.

Hi Philip,

Thank you for your help. I already resolve the issue. The issue is on the css of the form. The value of the z-index of the overlay is higher than the z-index of the content that's why it's blocking the form. I resolve it by custom javascript.

Here is the code:

NWF.FormFiller.Events.RegisterAfterReady(function(){var dialog = window.parent.document.getElementsByClassName('ms-dlgContent')[0].style.zIndex = 1511;});

Dear,

There is calculated value in  list settings, but with Nintex forms calculated formula you can do it in more easier and advanced way.