How to create order entry form with custom calculations?

  • Profile Image
    Victorine
    Asked on July 26, 2016 at 05:01 AM

    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

  • Profile Image
    Irshad
    Answered 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.

  • Profile Image
    Victorine
    Answered on July 26, 2016 at 09:14 AM

    Hello

    How do a write in Form Calculations:

    Net each - Discount = Total

     

    Thanks 

    Victorine

  • Profile Image
    Mike
    Answered 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.

    Thank you.

  • Profile Image
    Victorine
    Answered 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 

    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

  • Profile Image
    Nik_C
    Answered 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.

    Thank you!

     

  • Profile Image
    Victorine
    Answered on July 27, 2016 at 06:49 AM

    Thanks Nik

    How can I now copy the sales order line with the correct formulas 15 times?

  • Profile Image
    Irshad
    Answered 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.