Versions Compared

Old Version 5

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

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

Column

Does your organization use Google Apps? If so, you can combine frevvo + Google Sheets/Drive etc. to create some really cool and useful solutions. The Google Connector allows you to:

  1. Save submissions to Google Sheets
  2. Create dynamic drop down controls where the choices come form a Google Sheet.
  3. Update a Google Sheet with values from a form.
  4. Save documents generated by your frevvo form to Google Drive
  5. Single Sign On to Live Forms using your Google credentials.

Combining Google Apps Combining Google Sheets/Drive and provides interesting and useful ways to solve real business problems. From electronic signatures to dynamic pick lists to using Google Drive as a content repository to approval workflows, the combination just makes completing routine, day-to-day business tasks easier.The    provides a Google Connector that supports direct connectivity with between and Google Sheets and /Drive.   you to:Here are just a few useful solutions that you can try.

  1. Save your 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.

See the detailed instructions for connecting your forms/flows to Google Sheets and Drive.

 

 

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.1 and migrate their forms by this date . The frevvo Google Connector v1.4 and earlier will not work after this date. 

There are currently two versions of the Google Connector that are available:

  • Google Connector 2.0 is compatible with Live Forms v5.1.1. patch9, v5.3.8+ and v6.1.2.1+ releases. 

  • Google Connecotor 2.1 is compatible with versions 6.1.3+.

  • Google Connecotor 2.1.1 is compatible with versions 6.2.3+.

Follow the instructions here to upgrade the connector and here to upgrade . 

...

  1. a Google Sheet
  2. Create dynamic drop down controls where the choices come form a Google Sheet
  3. Populate Fields with Data from a Google Sheet
  4. Update a Google Sheet with values from a form.
  5. Save documents generated by your frevvo form to Google Drive
  6. Single Sign On to Live Forms using your Google credentials.

Cloud Customers

Cloud customers using the Google Connector for the first time will need to:

In-house Customers

In-house customers will need to:

...

...

hiddentrue

Again, Google Drive (and Apps) by itself is not really an Enterprise Content Management system. But, by combining frevvo with Google Sheets, Maps, Drive and other APIs, customers can easily create their own unique online forms and digital workflows that meet real-world business requirements, work automatically on mobile, are cloud-based and securely save the documents to Google Drive. Once in Drive, the documents can be managed, shared and searched.

The combination gets you closer to having ECM-like functionality at an incredibly affordable cost.

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.

Google Sheet Best Practice

Create a new user in your Google domain and make that user the owner of all the Google sheets that integrate with your forms/flows. This is recommended for the following reasons:

  1. It will eliminate confusion when searching for the correct sheet that integrates with your forms/flows.
  2. When you use the Google Wizards it will show all sheets that are available for integration in the dropdown.
  3. Reduces the chance of another user changing a column or worksheet tab name which could break integration with your forms/flows.