cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Workflow Hero

Calculation Field on Multi-Page Form

Hello Community,

 

I have a multi-page form that has calculation fields that are connected to certain columns in a SharePoint List.  As i page through the form the calculation field on one page changes as I move to the next creating bad data being saved at the end of the form on submit.  How can i keep the data from changing when a user clicks on a next button or previous button so that when they reach the end of the form and click submit the correct data is saved to the list?  I have a few fields that are going to be like this so this would be very helpful information.

 

Thank you,

Kevin

Labels: (2)
0 Kudos
Reply
6 Replies
Not applicable

Re: Calculation Field on Multi-Page Form

Hi Kevin,

 

There is one way which i came up. You need additional If clause in your calculated field formula which tracks in which state form is now. If you use tabs functionality from Vadim Tabakaman or other video tutorial there are fields which tracks which tabs is open now, so you can extend your calculated field formula to watch for these values.

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Calculation Field on Multi-Page Form

It doing the calculations is fine. I have a Drop Down that has types of rates(One Way, Round Trip, etc.) that then fire off the calculation field. But when user clicks Next to go to the next page the calculation field tied to using the drop down in the if statement resets to the False calculation versa staying at the right calculation that it did when the user chose the drop down. All my other calculation fields that do standard math stay the way they should just no the ones based off the drop down selection.

0 Kudos
Accept as Solution Reply
Not applicable

Re: Calculation Field on Multi-Page Form

Then you need to find why clicking button changes your field value to false. Because by default none button clicks can change values of the fields. Just with Javascript you can get this kind of functionality.

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Calculation Field on Multi-Page Form

Also found another work around for this problem of creating a tab system on the form vs using buttons.  Seems the buttons have like a post-back in them so when you click them to move forward and backwards its reloading the form and is resetting values to default. Still working at looking into this but i have used your suggest on looking at the state of the form as well as the tab system I found,

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Calculation Field on Multi-Page Form

What was your final solution?

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Calculation Field on Multi-Page Form

what is the false condition not recalculate  in this if:

if(tab=="Correct Tab", do calculation, don't recalculate) how do you say don't recalculate in the function/

0 Kudos
Accept as Solution Reply