Section | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
|
...
- In Google Drive, create a parent folder that will hold all the submissions for this form.
- In the Form Designer, simply click on the Doc Actions (what happens to my data) wizard and select the “Save to Google Documents” option.
- In the wizard that appears, enter your credentials (see above for how to get an access token).
- Select the parent folder you created earlier in Step 1.
- For Submission folder, you may enter a fixed value (not recommended) or use a template. In this case, we have chosen the StudentsName control. For example, if you enter John Adams in the Student Name control, the submission documents will be stored in a subfolder called JohnAdams.
Troubleshooting
Doc Post Failure
If a form/flow does not reach the specified folder in your Google drive successfully, notifies the tenant admin of the failure via an email. If flow administrator(s) are configured, the flow admin(s) receive the email instead of the tenant admin.
"An unknown error has occurred" message
You may see the error message "An unknown error has occurred" when selecting your Google sheet from the dropdown after you log into the wizard with your Google account and access code. To prevent this, set the Share permission for your Google Sheet to private then run the Save to Google Spreadsheet wizard. Change the share permission to public once the wizard is completed. Click here for other reasons this error may occur.