How do I set up my form to use points to calculate

  • Profile Image
    CatchALiftFund
    Asked 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?

  • Profile Image
    Kevin_G
    Answered 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. 

  • Profile Image
    Kevin_G
    Answered on August 09, 2017 at 11:45 AM

    @CatchALiftFund, 

    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.