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

    Custom calculations in a Matrix like way

    Asked by lgubbins on May 11, 2015 at 02:37 PM

    Hi there,

    I am using a matrix to collect data. I want to create a condition that, if under "Commission," the user types "Yes," the Amount will be multiplied by 0.1 and populate into "Commission Amount."

    I created this condition:

    If [Matrix] field contains [Yes]
    [Amount] * 0.1 
    Output field: [Commission Amount]

    I also want to create a condition when, if the user puts in "No," the commission amount will be zero.

    However, I noticed if the words "no" or "yes" appear anywhere else in the matrix (for example, if a field includes the name Norway), things get messed up. Is there a way to indicate in the Conditions wizard I want to search for the stand-alone words "Yes" and "No" and not words containing them? I tried quotation marks but it didn't work.

    Alternatively, is there a way to write conditions for matrix-level inputs? My problem would be solved if I could make the condition specific to one column.

    Thanks so much in advance!

    Page URL:
    http://form.jotform.us/form/51304702429145

    Screenshot
    conditions wizard matrix calculations
  • Profile Image
    JotForm Support

    Answered by Mike on May 11, 2015 at 04:24 PM

    Thank you for contacting us.

    Unfortunately, I have not found any workarounds for Matrix calculations in this case.

    You might consider using calculations based on standard inputs instead of the Matrix fields. I have created an example where you can add up to 3 items based on conditional logic.

    Form:

    http://form.jotformpro.com/form/51306073616954

    You can clone it to check the back end.

    Please feel free to contact us if you need any further assistance. We will be happy to help.

  • Profile Image

    Answered by lgubbins on May 11, 2015 at 04:27 PM

    Thanks!!!!

  • Profile Image

    Answered by raul on May 11, 2015 at 04:34 PM

    You can check this guide: http://www.jotform.com/help/90-Form-Field-Positioning to learn how to position fields in your form and you can also clone the example provided by Mike by following the steps provided here: http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

    Let us know if you need further assistance.
    We'll be happy to help.