Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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
  • If you are using Online, the Google Connector is already setup for you.
  • If you are using In-house, please read the installation instructions.

...

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

...

  1. Click the Doc Action button in the toolbar at the top of the form.
  2. In the wizard that pops up, select the Save to Google Documents button.
  3. Enter your login credentials.
  4. After your login has succeeded, the wizard will show the list of Folders (Collections) available. Sub-folders are not listed in the folder list.
  5. Select the collection you created earlier (Leave Approvals).
  6. 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}.
  7. Click the Finish button.
  8. Your form is now configured to save submissions to your Google Apps account. 

...