- izmirvodinajAsked on May 22, 2017 at 01: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:
The script is:
Thank you very much!
- JotForm SupportBJoannaAnswered on May 22, 2017 at 02: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.