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.
How can I validate a number in a single Matrix text box (cell)?Asked by czawodzi on July 08, 2015 at 05:06 PMAlso, I want to validate the numbers in a matrix text box, so that the teachers cannot make a mistake inputting the numbers. For instance, I have 5 columns across, 1, 1, 2, 3, 4. They cannot fill in a 4, into a column header of 1. I would like an error to appear if that happens. Is this possible? I tried the tools in conditions, but I am done playing, and I would appreciate an answer. Thanks so much! Cathy
To do this, you would need to add the field into the Form Calculation.
When you do, you will be shown the option to select which exact cell you would like to include (or cells), but in your case, you should select one of the cells that work best for you and have a validation for each cell set up accordingly.
Once you set the form calculations, you can hide them by clicking on the gear wheel icon on them and selecting Hide Field option:
The last piece of the puzzle is to set up the conditions to show an error or hide submit button if the field is not filled out properly.
For example, I would add Text element to the form that is to be shown on such occasions.
You can see more about the conditions here: Smart Forms Using Conditional Logic and here: How to show or hide a field in the form based on the other field input or selection
We are of course here Cathy if you need us so feel free to let us know about any issues or questions troubling along the way.
Hi, I really did try and understand the instructions, but I have failed. I added the Form calculation, under the matrix, on my form. I see how I can choose my text fields in my matrix. Now what? How do I create a validation rule? Thanks so much for your patience with me, I appreciate your help! Cathy
I understand that you want to restrict the users to enter only the value mentioned in the header for each field on a matrix. Please correct me if I am mistaken. It seems that it is not possible to validate the numbers/values on a matrix field. However, your requirement can be achieved by using the direct number field. This field has got an inbuilt validation to set minimum and maximum values. Also, you can perform calculations using these fields.
Let us know if that works for you.
Yes!! It works this way!!! Thank you!
In my colleague's name you are welcome.
For anyone else that finds this thread I would recommend taking a look at the following guide as well: How to perform form calculation using the "Matrix Field"