...
The information on this page refers to the Google Connector v1.4. Click here for the details about Google Connector v2.0.
| Tip |
|---|
customers building applications that are high volume and address critical business processes should not use Google Sheets in place of a production quality database. |
Installation
| Tip |
|---|
|
...
And the following Url parameters:
- media=jason json - This must be set as shown
- query=<query string> - This is where you specify which rows to match based on the data in your spreadsheet.
- update=<update string> - This is where you specify which cell(s) to update in the matched row(s)
- method=put - A hard coded Url parameter that must exist in the Url string
...
- Click the Doc Action button in the toolbar at the top of the form.
- In the wizard that pops up, select the Save to Google Documents button.
- Enter your login credentials.
- After your login has succeeded, the wizard will show the list of Folders (Collections) available. Sub-folders are not listed in the folder list.
- Select the collection you created earlier (Leave Approvals).
- Choose a name for the Submission Folder. This name should be unique for each submission. The best approach is to choose a combination of controls in the form that will generate a unique name. For example, if your form contains controls named EFulName and StartDate for employee's full name and start date of the leave, then choose: {EFullName}_{StartDate}.
- Click the Finish button.
- Your form is now configured to save submissions to your Google Apps account.
...