It seems like the calculations work sometimes.

  • Profile Image
    DefenderAmmo
    Asked on January 24, 2017 at 09:36 PM

    It seems like the calculations work sometimes. I have a string of calculations that I'd like to go into the "total cost" box. It seems like some add together for the total cost and some values just replace whatever is in there. Can someone help?



    This is a re-post of a comment on How to Perform Form Calculation Using a Widget

  • Profile Image
    Charlie
    Answered on January 25, 2017 at 12:08 AM

    I see you have 3 forms that are all updated today. Could you please provide us the specific form and the specific calculation that is not working? 

    However, I took a quick look at your form titled "DEALER ORDER" and I noticed that your "Total Cost $" is incorrectly setup. You can see below on my screenshot that there's a field that is showing "A-Z", this means that the input value fetched on that field will be treated as a text string, not a number value. Click to switch it to "0-9". 

     

    We'll wait for your response.

  • Profile Image
    Krissy
    Answered on January 25, 2017 at 09:27 AM

    Great. So I think I know the answer to this, but it looks like if there's a section break, "total cost" can't be calculated? It looks like the numbers in the next section push the previous section's out. I found a way to make it work- I think.

    On my Dealer Order form, I have added a hidden text box that calculates the total for each section, then will add the totals at the bottom in the "total cost" box. Is that how it should happen?

  • Profile Image
    Ian
    Answered on January 25, 2017 at 10:32 AM

    Yes this can be done as you described.

    You can also pass values between multiple forms by following the instructions provided at https://www.jotform.com/answers/625330-How-to-pass-value-from-one-form-to-another

    Hope this helps

     

  • Profile Image
    DefenderAmmo
    Answered on January 25, 2017 at 10:43 AM

    You guys are awesome. Thank you!!!