What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Inventory Widget CalculationsAsked by Keithy on March 14, 2017 at 05:56 PM
I am updating a form from 2016 to 2017. My form includes numerous inventory widgets which are summed using the calculation widget and are multiplied by the price. My prices increased for 2017 and I am trying to show this in the updated calculation.
For example, in the JDP section I am simply going into the calculation wizard and changing the dollar amount from $64 to $65 (First screen grab). However, when I do this simple change, the whole formula breaks and does not show any calculation in the live form (2nd image). Not sure what the issue is, would you be able to assist?
Sorry for the inconvenience.
Can you please try to update the widget with the items used for the calculation? Can you please also try to re-do the calculations on your form and see if this makes difference?
If the issue still persists, try also to clear your form's cache .
Let us know if you need further assistance.
Thank you for your assistance, per your suggestion, I have cleared the cache and updated all widget levels just to be sure, however it is still not working. Would you be able to be more specific? My questions again below...
1) In the Future Stars section - there is no response in the live field. I assume there is something either wrong with the inventory fields or the way the calculation is set up. Can you review my calculation in the "Future Stars Subtotal" section and tell me what the issues is? I
2) I am having the same issue in the "JDP Subtotal" section - nothing is calculating. Please advise on how to fix this formula.
I should also say, that this same exact process worked for my 2016 form, so not sure why it's broken now :-/
Thank you again.
I have tested your form and I was able to replicate issue in the Future Stars section and in the JDP section.
I have inspected your calculation fields and I noticed that some dollar signs "$" are set as number.
Dollar signs should be set as strings. To set them as strings simply click on them. They should be gray.
Please correct this on calculation fields that are not working. After that test your form.
Hope this will help. Let us know if you need further assistance.
Yay - it works!! This was the key, thank you very much!!
Feel free to contact us if you have any other issues or questions.