- 1thomh1Asked on November 24, 2014 at 05:14 AM
With most integrations with cloud storage you only require access to the stuff that Jotform creates, but I can see when trying to integrate Google Sheets, you ask for access to everything! I can't grant that access so I'm not able to use this feature :/
- JotForm SupportJanAnswered on November 24, 2014 at 10:05 AM
The steps regarding authentication and granting is permission is required for the integration to work.
Here's our guide on How to Integrate Form with Google Spreadsheet.
Setting up an integration with Google Spreadsheets should be quick and easy. Can you please tell us which part are you having issues with?
Let us know if need any help. Thank you.
- 1thomh1Answered on November 26, 2014 at 09:29 AM
I understand it needs permissions to access the drive, but when I set up the Drive integration for it to store the results there, it only asked for access to one folder, which it created itself, and nothing else.
The permission for this requests access to the full drive etc - surely you don't need that much access just to work on one Sheet?
- JotForm SupportWelvinAnswered on November 26, 2014 at 11:11 AM
I understand that you are concerned of the following permissions:
But the app only requires an access to the spreadsheet that is created by itself. Clicking "More Info" button would tell you what the permission is all about. I don't see any full permission access in the integration.
- 1thomh1Answered on November 26, 2014 at 11:42 AM
Please see below the more information boxes, which state it's able to 'view and modify existing spreadsheets' as well as share these with others. there's nothing in there about only having access to the ones Jotform crates. The tool for integrating with Drive only had one permission, while this one is SO MUCH more intrusive! You do not need that much permission!
- JotForm SupportWelvinAnswered on November 26, 2014 at 12:14 PM
Jotform does not necessarily modify any other existing spreadsheets from your account. The idea of the permission is to just solely access the specific spreadsheet that's been created by the integration.
View and Modify permissions are for updating the spreadsheet after it receives a submission. And as far as I know, the share spreadsheet permission is to let collaborators see the update to the form. Well, if only we can change the messages, but we cannot because that was generated by Google API. It's a bit confusing or misleading, but again, that's how the permission works.