Skip to main content

Hi Community,

 

I have a form that lets a user choose one of three options from a drop down. Based off the value of that drop down a calculation value control runs a formula and displays a value. Both the option chosen by the the user and the value calculated are stored into a SharePoint list.  However, if the user doesn't save it at that Panel and goes back or forward in the form and returns to Panel with the drop down the calculated value has changed to the wrong value.  How can you keep the drop down box value from resetting as a user goes through the form?

 

When user makes choice and the correct value is displayed

Before Panel next.PNG

After user as moved forward in the form then return to the form with calculations.

After Panel Next.PNG

As you can see the value for the formula was reset even though the drop down box still shows the choice the user picked.

Hi,


What's the rule that you have on the calculated field?

Also under the Calculated field you can set the following according to your needs:

Recalculate formula on view mode 

Yes   No        

Recalculate formula on new mode 

Yes   No        

Recalculate formula on edit mode 

Yes   No     

Hi Mike,

Here is the formula that is being used. Everything works till user moves to the next panel on the form then, then the formula and the variable fore Airport Travel Type goes back to being blank and messing up the calculation. The Form has 4 Panels the user goes through like a walk-through wizard would have.

if(equals(Airport Travel Type, "One Way"), if(and(lessThan(Depart Date Converted 2, Mileage Rate Change Date), lessThan(Return Date Converted 2, Mileage Rate Change Date)), 1, if(greaterThanOrEqual(Depart Date Converted 2, Mileage Rate Change Date), 2, if(and(lessThan(Depart Date Converted 2, Mileage Rate Change Date), greaterThanOrEqual(Return Date Converted 2, Mileage Rate Change Date)), 3,66))), if(equals(Airport Travel Type, "Round Trip"), if(and(lessThan(Depart Date Converted 2, Mileage Rate Change Date), lessThan(Return Date Converted 2, Mileage Rate Change Date)), 1, if(greaterThanOrEqual(Depart Date Converted 2, Mileage Rate Change Date), 2, if(and(lessThan(Depart Date Converted 2, Mileage Rate Change Date), greaterThanOrEqual(Return Date Converted 2, Mileage Rate Change Date)), 3,66))), 67))

If i set the recalculate formula to now it just doesn't do the calculations as if the field wasn't even there to show the user so setting those is of not help.

Hi Kevin,

As a test, place the Drop down and the calculated field on your next panel as well. To see if the user clicks next, the value is still same for both of them or is it being changed when you click on Next.

If this works, then you can keep them on the next panel, but hide them using the rule: 1==1, Hide.

Nothen changes, and its the when you click next or previous that the value for the drop down becomes blank which then the calculation field recalculates, but if if you go through the whole form and then save and submit all the data is correct other then for calculation based on what the user has chosen from the drop down.  For some reason no moving through the form that i have set up like a wizard going step by step with next buttons keeps making the choice the user picks back to blank but the drop down itself doesn't reflect that and when you submit or save the column shows the right information that the user did choose.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings