Calculated field does not recalculate when value(s) change?

11 years ago
Nov 6, 2014 3:06 PM UTC
8 replies
106 views
Translate All

+3

rubi

Hi everybody,

either I can't find it or the function is missing...

I've built an overtime request form with a calculated value field that calculates the difference between "From" and "To" in hours.
The formula (dateDiffHours(From,To)) works great, but the field can only be recalculated on "view", "edit" or "new" action.
Isn't there a possibility to trigger recalculation when one of the date/time fields changes?

Thanks for any hint or even confirming that the function isn't available.

BR, Rouven

A

+17

andrewg
Nintex Partner
11 years ago
Nov 6, 2014 3:44 PM UTC

I've seen a solution that had a similar issue with calculated fields and they used JavaScript to cause the calculated field to update when an item changed. James Cragle‌ may have more information.

Translate

Like

X

+12

xMikeX
11 years ago
Nov 7, 2014 1:41 AM UTC

Hello,

Are you using a "Calculated Field" control for your Total Field? I just tested this with a calculated field control and the change is instantaneous when either of my two date fields are changed.

Make sure you are using the names of your date controls,and not the item property fields within your formula. If you are doing what I described, then what version of Nintex are you currently using?

Thanks

Translate