Custom drop down options

  • jefftrubey
    Asked on August 10, 2018 at 5:25 PM

    Hi,

    I'm setting up an Ambassador program for college students.  A key part of our communications program will be to segment student ambassadors by college name.

    I'd like to use Jotform for the application for the program.  However, I can't see how I can upload a Excel or .cvs file of our college database for use in a drop down form (or better yet, auto pre-populating in field as they enter their school data -- like Google search).  It is key to our program that we are able to have a standardized school name field in order to be able to segment our communications.

    It would be like adding a "predefined options", but with our college data instead of "states".  I really don't see entering 2000+ college names manually in the drop down menu "options".

    Thoughts?  Jeff

  • Richie JotForm Support
    Replied on August 10, 2018 at 6:11 PM

    We can populate the fields using spreadsheet to form widget.

    Custom drop down options Image 1 Screenshot 20

    Here is a guide:https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

    Please give it a try and let us know your thoughts.

    Thank you.