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

Calculated Value Based on Hidden Field

Jump to solution

Is it possible to make a calculated value control work on a hidden field? I am working on a mileage reimbursement form and I need to calculate the number of miles based on a field that I would like to hide. 

The first number of miles field is a text field where if the user selects "other" in either of their location boxes, they have to manually enter the number of miles. The second number of miles field is a calculated value that pulls in the number of miles from a list based off of our locations, and it changes depending on if the user selects round trip or one way. The hidden field calculates based off of what the users select in the location fields and it tells the calculated miles field what column to pull from on the list. 

0 Kudos
Reply
3 Replies
Automation Master
Automation Master

Re: Calculated Value Based on Hidden Field

Jump to solution

yes, if you hide the control with formatting rule it should be recalculated if any of values/controls it depends on changes.

Reply
lgiambar
Nintex Newbie

Re: Calculated Value Based on Hidden Field

Jump to solution

I was not able to make that work. I ended up creating a work around by making the text of the fields I want hidden 1pt font and the same color as the background so that the user can't see them! 

I dont know if the functionality if the hidden fields is different in this case because of the fact that the fields are in a repeating section. 

View solution in original post

Reply
anthonynhn999
Nintex Newbie

Re: Calculated Value Based on Hidden Field

Jump to solution

Another work-around is to create a rule (always true) to hide the calculated values. It works for me (i.e. the field is hidden but the calculated value is still applied to the form) in Nintex Forms for Office 365.

0 Kudos
Reply