- VictorineAsked 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.
- IrshadAnswered on July 26, 2016 at 06:53 AM
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.
- VictorineAnswered on July 26, 2016 at 09:14 AM
How do a write in Form Calculations:
Net each - Discount = Total
- JotForm SupportMikeAnswered on July 26, 2016 at 10:29 AM
It seems to be already implemented with conditional calculation on your form.
If the discount should be in %, you can use the next formula.
- VictorineAnswered on July 27, 2016 at 04:17 AM
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.
- JotForm SupportNik_CAnswered on July 27, 2016 at 06:12 AM
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.
- VictorineAnswered on July 27, 2016 at 06:49 AM
How can I now copy the sales order line with the correct formulas 15 times?
- IrshadAnswered on July 27, 2016 at 08:13 AM
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.