-
mstrainAsked on February 26, 2019 at 3:05 PM
Hi, Can I get the google sheet integration to add the spreadsheet to an existing workbook?
i.e main workbook called 'Main' with named sheets added, i.e. sheet1/sheet2.
Jotform one submissions go directly to main, jotform 2 submissions go to worksheet 1 etc
-
David JotForm Support ManagerReplied on February 26, 2019 at 5:12 PM
We have an integration with Google Sheets: https://www.jotform.com/help/228-How-to-Integrate-Forms-with-Google-Sheets
Each form you integrate will be sent to a specific folder that is defined in the integration, not to an existing folder.
-
LGHSgradnightReplied on February 28, 2019 at 4:38 PM
I'm just another user. I've been doing this for quite some time. Use the "Importrange" function on the sheet in the workbook you want. You can have multiple Importrange's in a workbook, each on it's own sheet. I think this will accomplish what you want.
-
David JotForm Support ManagerReplied on February 28, 2019 at 6:06 PM
@LGHSgradnight, thanks for sharing this alternative option, this will be surely useful for users who might want to do the same with their integrated sheet.
-
mstrainReplied on March 1, 2019 at 4:23 AM
Thanks @LGHSgradnight, brilliant option.