-
SanctuaryHostelAsked on June 2, 2021 at 3:50 PM
When i authenticate it shows spreadsheets in my drive but not the shared drive
-
Laura JotForm SupportReplied on June 2, 2021 at 10:15 PM
Hi,
Unfortunately the Google Sheets integration lets you upload the submissions only to a personal drive, and there is no option to use a shared drive.
As a workaround, you can either use Google Workspace shortcuts to post the submission from your personal drive to the shared drive, or then create an integration with Zapier. With Zapier, you can connect JotForm directly to the shared drive.
Let us know if you need further assistance. -
SanctuaryHostelReplied on June 2, 2021 at 11:11 PMHi,
I understand, i did use my personal drive. When I connected it to the
existing spreadsheet and used an existing workspace name, it then created a
duplicate of that worksheet instead of using the existing. Is there a way
around that?
Best Regards,
Ace M
... -
Bojan Support Team LeadReplied on June 3, 2021 at 6:31 AM
Greetings.
Unfortunately, it is possible to select only Sheets that are on your account. You could add shortcuts of your Sheet to the shared Drive.
Let us know if you have any additional questions.
-
SanctuaryHostelReplied on June 3, 2021 at 3:33 PMI am not talking about shared drive anymore, please look at my last message
carefully and provide the requested information
Best Regards,
Ace M
... -
Laura JotForm SupportReplied on June 3, 2021 at 5:03 PM
Hi Ace,
Apologies for the confusion.
Unfortunately, currently that is how the integration is designed to work - when you select to use an existing Spreadsheet, the integration will still create a new worksheet within the Spreadsheet.I have forwarded this to our developers as a feature request, and I noticed that there were already a couple of similar requests existing. However, we cannot guarantee an ETA, or that the feature will be implemented.
As soon as we have any updates, we will inform you on this ticket. -
SanctuaryHostelReplied on June 3, 2021 at 5:22 PMGot it thanks, hopefully that can be implemented
Best Regards,
Ace M
...