Skip to main content
Nintex Community Menu Bar

Nintex form does not recalculate calculated fields on form edit

  • November 8, 2016
  • 3 replies
  • 33 views

Forum|alt.badge.img+6

Hi all,

I'm creating a travel expense claim form which captures an employees total miles and parking in a pay period. This is done using calculated fields. This function works as intended.

 

There will be times when the form owner will have to edit it after it has been saved. In my testing, when I edit the form, all of the calculations resolve to zero's. The fields will only recalculate when I place my cursor in the form field and click out of it.

 

What I'm trying to do is have the form show the calculated totals when the form is edited or at the very least recalculate the totals when any form field is edited. I've ensured I'm using named controls in my calculated fields (Eric Harris‌). I did find a possible solution on a post by ‌ using javascript but the example uses the date difference and I can't seem to replicate the javascript to work with my problem - likey because my javascript skills are as good as my Nintex skills.

 

I've done a quick video to show what I'm talking about.

 

Any help is appreciated.

3 replies

Forum|alt.badge.img+4
  • November 8, 2016

Hi Andrew,

We had the same issue with one of the releases and it was bug and this issue was fixed in the new release. What version are you on? Probably an update to a latest release will help.


Forum|alt.badge.img+10
  • November 8, 2016

Hi Andrew,

You can do a conditional calculation. If the field value is null then do the calculation, or get the data from the field.

If(IsNullOrEmpty (FldName), Sum(Control), FldName)


Forum|alt.badge.img+6
  • Author
  • Rookie
  • November 8, 2016

Yep. I went to the new version and it works fine now.

Thanks for the help.