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

    How can I populate an answer from a google sheet column?

    Asked by Artie on March 14, 2016 at 09:05 PM

    I have a google sheet with over 1000 offices my reps visit.  When they are making their sales calls they use jotform to give me reports.  One question on the survey is "Office Visited:"  I would like this answers to populate from my google sheet.  How is this possible?

     

    Thank you!

     

     

    Page URL:
    https://form.jotform.com/53484137053151

    sheet how a how can i
  • Profile Image
    JotForm Support

    Answered by Chriistian on March 14, 2016 at 10:33 PM

    Do you mean you want to populate the answer from google sheet into your form?

    A possible method would be to create a formula from the Google spreadsheet that makes all the offices visited links so that when clicked, they open a form, and pre-fills the Office visited field. Here's a demo so you can see it in action: https://docs.google.com/spreadsheets/d/1zSJ-rHcsGAeSOPJFlPt8opuLYaa18RkS18vVVg4sfCQ/edit#gid=0 

    Do let us know if you need further assistance.
    Regards.