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

    I would like to populate data from google sheet in to drop drown.

    Asked by dataadmin on September 03, 2016 at 06:44 PM

    This google sheet contains students data created from Jotform earlier.

    I would like to make this student name and id combine as drop down selection box in another attendance form i would like to create.

    populate data sheet drop drown in
  • Profile Image
    JotForm Support

    Answered by jonathan on September 03, 2016 at 11:07 PM

    Currently there is no automated means to populate the form fields (i.e. options in Dropdown list) with data coming from external data source like google sheet.

    You will have to do it manually via copy/paste method. That is copy the data from the spreadsheet and paste it on the Dropdown lists .

    Hope this help. Let us know if you need further assistance.