How to set up condition for dropdown using equal or greater than

  • Profile Image
    Joy
    Asked on May 21, 2015 at 05:37 PM

    I have a dropdown box with sets of values. When a selection is made, i want to check if the value selected is equal or greater than the value in another field. If it is, then it will show ok status, otherwise, invalid status.

    Right now there is no greater/less condition for the dropdown box.

  • Profile Image
    david
    Answered on May 21, 2015 at 06:57 PM

    Hi,

    For the "Greater Than" and "Less Than" option to show up, you need to use a "Number" field.  You then use the field tag for the second field to compare the two:

    Here is a quick test form I setup to show you how it works:

    http://form.jotformpro.com/form/50685154904963

    http://www.jotform.com/help/42-How-to-clone-an-existing-form-from-a-URL

    If you have any further questions, let us know and we will be happy to help.

     

  • Profile Image
    coigis
    Answered on May 21, 2015 at 07:01 PM

    David,

    I understand that it needs to be a Number field. However, I need a dropdown to limit user's entry. Can a dropdown be a Number field?

  • Profile Image
    david
    Answered on May 21, 2015 at 07:07 PM

    My apologies, by number field, I meant an actual number field, not a dropdown:

    Though the greater than less than comparison cannot be used on a dropdown field, you can use the dropdown selections to populate a number field, then compare the number fields.  I just setup on quick condition:

    And added that to my test form to show you that working:

    http://form.jotformpro.com/form/50685154904963