Need to integrate JotForms and Google Sheets?

  • izmirvodinaj
    Asked on May 22, 2017 at 1:34 PM

    I have a jotform that requires users to select information from a dropdown. I would like the dropdown to be able to get the values from a google spreadsheet. So for example, I on Sheet2, on cells B20:C45 I have some names. I would like the jot form dropdown to pull those names, and if I remove some from the sheet, I would like JotForm to remove them as well. 

    I searched this question and found the following answer using a script on google sheets, but the script does not work. Any help would be highly appreciated. I do not know coding, so there may be just a small mistake that I am not able to see.

    The problem is on the script is: 

    Need to integrate JotForms and Google Sheets? Image 1 Screenshot 30

     

    The script is:Need to integrate JotForms and Google Sheets? Image 2 Screenshot 41

     

    Thank you very much!

  • BJoanna
    Replied on May 22, 2017 at 2:56 PM

    Our integration with Google Spreadsheet is sending the data form the form to the spreadsheet, not other way around. You can not pass the data from your spreadsheet to populate fields of field options on your form. It is also not possible add custom scripts to the form. 

    This can only be achieved if you embed your form to your website using full source code and if you add your custom script there. Please note that this is out of our scope and if you are not familiar with coding, I would suggest you to hire a developer to do it for you. 

    If you want to pre-populate your form with some data from your spreadsheet, you can do it manually your our pre-populate app: http://prepopulate.jotform.io/ 

    Let us know if you need further assistance.