-
jefftrubeyAsked 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 SupportReplied on August 10, 2018 at 6:11 PM
We can populate the fields using spreadsheet to form widget.
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.