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.


  • Profile Image

    How to creae order entry form with custom calculations?

    Asked by Victorine 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

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

    Screenshot
    entry form order form calculation form
  • Profile Image

    Answered by Irshad 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

    Answered by Victorine on July 26, 2016 at 09:14 AM

    Hello

    How do a write in Form Calculations:

    Net each - Discount = Total

     

    Thanks 

    Victorine

  • Profile Image
    JotForm Support

    Answered by Mike 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

    Answered by Victorine 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
    JotForm Support

    Answered by Nik_C 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

    Answered by Victorine 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

    Answered by Irshad 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.