How to create order entry form with custom calculations?

Hello

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.

Victorine

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.

Hello

How do a write in Form Calculations:

Net each - Discount = Total

Thanks 

Victorine

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.

Thank you but I think I am doing something wrong.  Please can you have a look at 

https://eu.jotform.com//?formID=61243046224344

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.

Thank you

Victorine

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.

Thank you!

Thanks Nik

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.