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

    Problems using Form Calculator on Matrix table field

    Asked by Venesa on May 15, 2017 at 08:14 PM

    How do I calculate the Amount when someone enters under the QTY.

     

    I want sell an item that is $4.00, So when they enter how many they want under the QTY tab I would like the corresponding amount to show up under my total for quantity and total for balance.

    So, Qty is 1 = $4.00   OR  Qty 2 = $8.00.  I added a screen shot of my form.  

     

    Thank you!

    Venesa

     

     

    Page URL:
    https://form.jotform.us/71335683784163

    Screenshot
  • Profile Image
    JotForm Support

    Answered by jonathan on May 15, 2017 at 11:09 PM

    You are using the Matrix table field in your form calculation. It has a different approached than the form calculation using individual input field.

    I suggest you review these user guides: 

    How-to-Perform-Form-Calculation-in-the-Matrix-Field

    Calculate-Values-in-the-Input-Table-Through-Condition

     

    Let us know if you need further assistance.

     

     

  • Profile Image
    JotForm Support

    Answered by jonathan on May 15, 2017 at 11:32 PM

    Please test my demo form https://www.jotformpro.com/71349109444962

     

  • Profile Image

    Answered by Venesa on May 15, 2017 at 11:36 PM

    Yes, Johnathan.  That's exactly what I want.  Thank you!!! I already saw the videos of the other reply.  Thank you thank you!  One more question....Is there a way to put it in as a dollar amount in the amount section?

  • Profile Image

    Answered by Venesa on May 15, 2017 at 11:39 PM

    the demo didn't work for me like your screen shot.

    Can someone actually type in 1 for the quantity and the amount automatically say $4.00?  I think my form already does that

  • Profile Image
    JotForm Support

    Answered by jonathan on May 15, 2017 at 11:42 PM

    I made a revision since I noticed that the amount can be fixed to $4.00 only.

    Here is the other demo form https://form.jotformpro.com/71349009431957

    You can prefix the currency sign before the formula

     

     

     

     

  • Profile Image

    Answered by Venesa on May 15, 2017 at 11:48 PM

    You are a genius.  Thank you.  Now how do i do it for my form? Sorry to ask

     

  • Profile Image
    JotForm Support

    Answered by jonathan on May 16, 2017 at 12:11 AM

    I suggest you clone this form https://form.jotformpro.com/71349009431957  so that you can better review how it was created on your Form Builder.

    User guide: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL