Section | ||||||||
---|---|---|---|---|---|---|---|---|
|
...
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 . |
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. |
Note |
---|
Google users with 100+ pre-existing documents in their Google Drive may have issues using the frevvo Doc Action Wizards to connect forms/flow to their Google account. The login screen in the wizard may hang or throw an unexpected error. If you experience this issue please:
In the form/flow Manually Set Doc URI, do the following:
The big ID after the key/ comes from the Google Spreadsheet URL that you see in the browser. It looks like this: https://docs.google.com/a/frevvo.com/spreadsheets/d/1ytf4_eeN7b77321BxLsZfOeg6oWlgAnqI4OglDFASGg/edit#gid=0 The parameters indicated in the URL: ?user=xxx&password=yyy. You should URL encode the user and password though this may not be required e.g. joe@gmail.com will work fine. You don't need to URL encode the @. Some characters must be encoded e.g. &. If you aren't sure, encode it (http://meyerweb.com/eric/tools/dencoder/). This workaround bypasses the wizard completely and points the form to the Connector directly via a manual doc URI. |
...
- Click the what happens to my data icon 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 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 Drive.
...
Warning |
---|
|
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.
Ticket | Description | Work-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:
|
#17952 | Some number values update to date values in Google Sheets | In 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. |
...