limit for a specific numeric field base on another field in the form

  • tdada
    Asked on November 26, 2022 at 7:17 AM

    Good day

    Is it possible to create a limit for a specific numeric field base on another field in the form.

    For example in the 2 fields below ,if I want to ensure the Net Salary field always contains a value less than

    the one in the gross salary field.

    Is there a way to limit users in jot form not to enter a value above the one they have entered in the Gross Salary field. For example if user enter 5000 in the Gross Salary field they cannot enter a number larger than 5000 in the Net Salary field.

    limit for a specific numeric field base on another field in the form Image 1 Screenshot 20

  • Mafe_M JotForm Support
    Replied on November 26, 2022 at 7:34 AM

    Hello,

    Thank you for reaching out to Jotform Support. I’m sorry you're having difficulties with this. Let me help you set that up. Since you have a couple of active forms, can you send me the link to your form so I can take a look at it for you?

    Once we hear back from you, we'll be able to move forward with a solution.




  • tdada
    Replied on November 28, 2022 at 1:22 AM

    Good morning

    Find the below link

    https://form.jotform.com/221492345987063

  • Lorelie JotForm Support
    Replied on November 28, 2022 at 3:27 AM

    Hello Eric,

    Thank you for reaching out to Jotform Support. Please allow me some time to look into this. I’ll get back to you as soon as I can.

  • tdada
    Replied on November 28, 2022 at 4:45 AM

    Kindly waiting...

  • Lorelie JotForm Support
    Replied on November 28, 2022 at 5:57 AM

    Hello Eric,

    Thanks for patiently waiting. For you to do that, you need to change your short text element for your gross salary to a number field and add a condition to it. For the example that you gave to us, I created 2 fields for the Net salary field, one with an entry limit of a maximum of 5,000 so they cannot enter a number larger than 5,000 in the net salary field if the user enters greater than 5,000 in the gross salary field.

    1669631246 63848d0ec9098 63848d0ec905c Screenshot 10Here's a screenshot below of the condition that I added:

    1669631456 63848de0e729f 63848de0e7260 Screenshot 211669631462 63848de6dc30e 63848de6dc2c3 Screenshot 32

    Check out the screencast below to see my results:

    1669631658 63848eaa3ffc9 63848eaa3ff8b Screenshot 43

    For a closer look, here is the cloned form 223312048337449, feel free to clone my form.

    Give it a try and let us know if you have any other questions.

  • tdada
    Replied on November 28, 2022 at 6:11 AM

    Good day

    Thank you for trying to help, however 5 000 was just an example, the value in the gross salary field can be any value but the net salary field should not simply exceed that value

  • tdada
    Replied on November 28, 2022 at 6:43 AM

    I simply want to know if this is possible or not in jotform


  • Mary JotForm Support
    Replied on November 28, 2022 at 6:46 AM

    Hi Eric,

    I would suggest adding this paragraph field:

    1669635632 63849e30c7e73 63849e30c7e36 Screenshot 10

    Then add the following condition:

    1669635741 63849e9df1421 63849e9df13e4 Screenshot 21

    Once the number entered in Net Salary is Greater than the Gross Salary, the paragraph field is shown and all our fields are hidden. Check out my sample form here.

    1669635967 63849f7f40315 63849f7f402d7 Screenshot 32

    Let us know if you have any other questions.



  • Israel JotForm Support
    Replied on November 28, 2022 at 6:47 AM

    Hello Eric,

    Thanks for getting back to us.  Unfortunately, it's not possible to limit the numeric entry in the Number field. I think what you need is the input mask option property of the field and this is not available in the Number's properties.

    You can use the Short Text Entry field instead of the Number Properties, then set the validation to Numeric type. Then you can follow this guide for Input Masking.

    1567191086Input Mask Screenshot 10

    Reach out again if you have any other questions