- CatchALiftFundAsked on August 08, 2017 at 10:23 AM
Hello, I am creating an order form. The items on this order form need to be given a point value, which I have figured out. As items are selected, I would like the points to come off of the main amount of points allotted. I would also like this running total to be seen. Could you kindly help me figure this out?Page URL:
- JotForm SupportKevin_GAnswered on August 08, 2017 at 11:45 AM
I have reviewed your form and noticed you have some conditionally calculated values, the conditions are related to the fields "Medicine Ball Selection" and "Versatile Dual Grip Medicine Balls".
I would like the points to come off of the main amount of points allotted.
May you provide us more details about this requirement?
You're currently using a radio button and a check box field, once an option is selected it's included in the calculation you currently have.
I would also like this running total to be seen. Could you kindly help me figure this out?
It's possible to get a total on your form, you will need to add a widget in order to include the needed fields and perform the needed calculations, please check the following guide in order to get more details about it: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget
I hope this helps.
- JotForm SupportKevin_GAnswered on August 09, 2017 at 11:45 AM
Unfortunately, your reply did not reach this thread, but I received it via email and it's quoted below:
"Answered by CatchALiftFund
I followed the steps above and found it to be successful.
The only issue is, when I look at the order, the number of points fields are shown. How can I hide them so they are not seen in the excel spreadsheet and the order form?"
To hide form fields, please follow this guide: https://www.jotform.com/help/434-How-to-Hide-Form-Fields
Now, if you want to hide the fields from the Excel report, you could do it on the report configuration page, here is also a link that will help you doing that: https://www.jotform.com/help/101-How-to-Create-an-Excel-Report
If you are downloading the report through the submissions page, then you only need to select the fields that you need to include by clicking on the settings button:
I hope this helps.