JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
How to create order entry form with custom calculations?Asked by Victorine on July 26, 2016 at 05:01 AM
I am designing another form. When we receive customer PO's we hand write the information on our Customer Order Entry form along with the pricing - our form is below as a screen shot.
I am designing a customer order entry form which is in the URL below and have found a Widget that fits nicely but does not do any calculations. I like the Widget that I have installed as we can 'add or delete a row' and this is of particular interest as one product can have many other sub-products which all have to go on the form and will be added by different people in the company.
Please can you let me know if there is anything that would suit my requirements.
I did look at the Purchase widget but don't think it will do what I want.
I look forward to hearing from you and thank you for your help again.
I am sorry, unfortunately you cannot perform calculations with dynamic fields, such as Configurable List widget or Infinite List widgets.
If you are interested about Form Calculations in general, I would advise you to take a quick look at our guide on How-to-perform-calculation-in-the-form
Please let us know if you need further help.
How do a write in Form Calculations:
Net each - Discount = Total
It seems to be already implemented with conditional calculation on your form.
If the discount should be in %, you can use the next formula.
Thank you but I think I am doing something wrong. Please can you have a look at
The formula was correct initially after you gave me the percentage formula but I duplicated the order entry row about 15 times checking to keep the formulas but it went wrong.
Please help if you can.
You did everything Ok except that your formula was a mix of string and numerical characters, this is what I mean:
In your formula:
You can see that minus and bracket are light grey, that means that they are represented as string signs, what you have to do is just click on them and they will turn dark grey, which means they will be represented as calculation signs in formula:
And that will work as intended, I just did a test:
Hope it helps.
Please let me know if you have any further questions.
How can I now copy the sales order line with the correct formulas 15 times?
As in the sales order line of formula, every field is independent, so the direct copy of the sales line with same formulas will not be possible. You would require to manually add a new row with the reference of the reference of sales order reference line fields. And after that would require to create the conditions again.
Please let us know, if you need further assistance.