Versions Compared

Key

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

 supports direct connectivity with Google Documents and Spreadsheets. The Google Connector allows you to:

  1. Save submissions to Google Spreadsheets
  2. Read data from Google Spreadsheets
  3. Update data in a Google Spreadsheet 
  4. Store form submissions directly into your Google Apps account.
  5. Format emails or confirmation receipts using an online Google Document; and store form submissions directly into your Google Apps account.
Column

On this page:

Table of Contents
maxLevel1

Warning

Google will no longer support the Google Documents List API 3.0 after April 20, 2015. All customers must upgrade their frevvo Google Connector to version 2.0 and migrate their forms by this date . The frevvo Google Connector v1.4 and earlier will not work after this date. 

If you are using  v5.1.1+ you must upgrade to patch 9 to use the Google Connector 2.0. Follow the instructions here to upgrade the connector and here to upgrade . 

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.

...

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

...

Form submissions can be saved to your Google Apps Premier account. Note that Google Apps for Education account are currently not supported.

The first step is to create a Collection (effectively a folder) in your Google Apps account. This will be the location where your form submissions will be stored. For example, create a Collection called Leave Approvals.

width
Column
50px

Create a new Google Apps Collection

Use the Google Documents wizard

Column
width50px

Use the Google Documents wizard

 

  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. 

 

50px
Column
width

Image ModifiedCredentials, Folder, Submission Folder

Warning

Do not use spaces or special characters when creating submission folder names.

Google Documents

...