kkittinger
Nintex Newbie

Drop Down Value Not Saving for formula on Mutli-View Form

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.

0 Kudos
Reply
5 Replies
xMikeX
Automation Master
Automation Master

Re: Drop Down Value Not Saving for formula on Mutli-View Form

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 

     

Recalculate formula on new mode 

     

Recalculate formula on edit mode 

  
0 Kudos
Reply
kkittinger
Nintex Newbie

Re: Drop Down Value Not Saving for formula on Mutli-View Form

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))

0 Kudos
Reply
kkittinger
Nintex Newbie

Re: Drop Down Value Not Saving for formula on Mutli-View Form

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.

0 Kudos
Reply
kapilkjoshi
Automation Master
Automation Master

Re: Drop Down Value Not Saving for formula on Mutli-View Form

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.

0 Kudos
Reply
kkittinger
Nintex Newbie

Re: Drop Down Value Not Saving for formula on Mutli-View Form

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.

0 Kudos
Reply