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

    Matrix Field: How can I prevent a negative number from being entered?

    Asked by Jerole on November 07, 2016 at 02:37 PM

    I have an order form using radio check and a matrix. I am exporting it into FileMaker to create several custom reports for all those that need to know for order fulfillment.

    I noticed 1 field was a negative number. How do I prevent this?

     

    Page URL:
    https://form.jotform.com/60293960975164

    entered how a how can i
  • Profile Image
    JotForm Support

    Answered by Jim_R on November 07, 2016 at 06:36 PM

    Hello, since you never mentioned which field you're referring to, I checked your Submissions and found a negative value on your Matrix Field:

    If that's what you're referring to, then no, there's no innate feature/option to prevent users from entering negative values on the Numeric Textbox of a Matrix Field.

    As a workaround, you may use a visual cue (an error message of sort) that will tell them that it's not allowed by using Conditions and a Text Field. Here's what I had in mind:

    To achieve that, just do the following:

    1. Drag a Text field to your form.

    2. Create your condition as shown below:

    This means that IF the Matrix Field contains a - THEN show the visual cue that Negative Values are not allowed (optionally, you may also hide the Submit button to prevent them from sending the form if the visual cue error is displayed)

    Here's a cloned copy of your form https://jotform.com/63117369684970 showing that. Feel free to clone it if you need to see how I set it up.

  • Profile Image

    Answered by Jerole on November 07, 2016 at 07:04 PM

    Thanks I'll give it a try.