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

    Is it possible to do table lookups for dropdown choices

    Asked by hilltopkennels on August 14, 2014 at 12:12 PM

    I need to allow a user to choose from a dropdown and based on the dropdown choice made, a value substituted via a lookup table into another field.

     

    i.e

    Chihuahua - Small

    Rottweiler - Large

    St Bernard - Giant

    Border collie - Medium

    Irish Terrier - Medium

     

    User chooses the dog breed and the system automatically populates the breed size into another field.

    table choices size and
  • Profile Image
    JotForm Support

    Answered by Kiran on August 14, 2014 at 04:03 PM

    I understand that you want to populate the size into a field when the user chooses the dog breed from a drop down. 

    Please let me know if I am missing anything here. Please take a look at this form and let me know if it works for you.

    http://form.jotformpro.com/form/42256358122956?

    Please get back to us if you need further assistance. We are happy to assist you.

  • Profile Image

    Answered by hilltopkennels on August 14, 2014 at 04:06 PM

    I can see how that works but we would need over 150 breeds of dog. Somewhat arduous to setup that many rules, was hoping a neater way would be via a lookup function of some kind.

  • Profile Image
    JotForm Support

    Answered by Kiran on August 14, 2014 at 05:29 PM

    Unfortunately, there is no feature available as such. However, please allow me some time to work on this and get back to you if I can suggest you a workaround.

    Thank you for your patience.