JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Custom calculations in a Matrix like wayAsked by lgubbins on May 11, 2015 at 02:37 PM
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!
Thank you for contacting us.
Unfortunately, I have not found any workarounds for Matrix calculations in this case.
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.
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.