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

Refresh Calculated Value form field by JavaScript.

Jump to solution

Hi all,

we have a requirement to force a calculated form field to refresh. It has a variable of ErrorCount. It is not connected to any SharePoint list column. 

We need to refresh the field this way as the calculated form field uses the lookup run-time function to return how many items are in a particular list, and give the total amount of items, using below formula:

count(lookup("ErrorList","Reference",Reference,"ID",true))


Whilst the form is open the list - that the calculated field returns the count from - gets updated - another item is added to it. When this happens we post a function called callback to the form.

Inside this function we need to update the calculated form field to show the new list total/ item count.

The function callback is successfully called, as we have confirmed with an alert, but the calculated form field is not  being refreshed, updated.

Inside our callback function we have tried:

function callback() {

alert('function called OK');

NWF$('#' + ErrorCount).trigger('blur');

NWF$('#' + ErrorCount).trigger('change');

}

Any idea on how to get the calculated form value field to recalculate /update?

Reply
2 Replies
Highlighted
aartishaw
Nintex Newbie

Re: Refresh Calculated Value form field by JavaScript.

Jump to solution

Below is the code you can use to refresh the calculated column

NWF.FormFiller.Functions.ProcessOnChange(NWF$("#" + txt_count);

client id of control : NWF$("#" + txt_count)

refer: Force refresh the nintex form using javascript 

View solution in original post

0 Kudos
Reply
stantond
Nintex Newbie

Re: Refresh Calculated Value form field by JavaScript.

Jump to solution

I just wanted to add to this since I was running into a similar issue. I was setting the value of a control inside a repeating control and needed it to update the rule on each instance of a control inside the repeater.

 

Here is what ended up working for me (replace control_inside_repeater to whatever you set the CSS Class of your control to).

NWF$('.control_inside_repeater').each(function(control){
    NWF$(this).find('input').blur();
    });

The part that had me stuck for awhile was the need to do the find('input') rather than just trying to blur NWF$(this).

 

I also ended up needing to wrap that in a 2 second setTimeout function to allow all of the values to be set before it tried to retrigger the form rules.

0 Kudos
Reply