Versions Compared

Old Version 82

changes.mady.by.user Former user

Saved on

compared with

New Version 83

changes.mady.by.user Former user

Saved on

Key

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

 supports direct connectivity with Google Sheets and Drive. The Google Connector allows you to:

  1. Save submissions to Google Sheets
  2. Read data from Google Sheets
  3. Update data in a Google Sheets
  4. Store form submissions directly into your Google Drive.

Watch this video for a demonstration of how can be used to deploy forms and workflows that generate documents and automatically upload them to Google Drive.
Column

On this page:

Table of Contents
maxLevel2

...

  1. Click the  what happens to my data icon 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 available. Sub-folders are not listed in 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 Drive. 

...

Credentials, Folder, Submission Folder  
 

 

Warning
  • Do not use spaces or special characters when creating submission folder names.
  • If you configure the Submission folder field with a template then enter a value with a special character, ex:test@frevvo, the folder that is created will have the @ encoded.

Format & Email data using a Google Document

Info

The Google Document wizard is deprecated. Use the standard Email wizard which now supports HTML and CSS formatting plus form field templates to pull data entered into the form into your email message subject and body.

Google Connector Known Issues

Please report any issues or feedback to us here.

TicketDescriptionWork-around
#16848

Google Spreadsheet - Boolean control : Fetching values true/false should not be case sensitive

Google sheets automatically converts true, True, false, and False values to upper case. Click here for more information. A checked Boolean control value is stored in your spreadsheet  as TRUE.  This might cause an issue when reading from Google spreadsheet, and setting the value of the Boolean checkbox. Implement one of the following as a workaround:

  • Convert to lowercase before setting the value of the T/F control

  • Format the cells in your spreadsheet as Plain Text by clicking the 123 button and selecting Plain Text.

  • Enter the text as: 'true - (the ' prevents Google sheets from changing the value to upper case).

#17952Some number values update to date values in Google SheetsIn some cases, Google Sheets may change valid number values to dates values. The best way to handle this situation is to write scripts to clean up the bad data in your Google Sheets.

 

 

 

...