Versions Compared

Version Old Version 3 New Version 4
Changes made by

Megan Ellis

Megan Ellis

Saved on

Key

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

...

...

Section
Column

 business rules are used to retrieve and update data in Google sheets via the Google Connector. One advantage to initializing your form/workflow from a Google sheet is to provide business users, who may not be familiar with , an opportunity to modify the Google sheet to make changes. Once modified, the changes in the Google sheet are reflected in the form/workflow without further action.

Designers are encouraged to:

  • Use http headers for authentication in  rules. 
  • You can identify your Google sheet/worksheet, using the ssname and wsname query parameters. 
  • frevvo recommends using the spreadsheet key instead of spreadsheet name to identify your Google Sheet
  • Pass payloads and headers as native JavaScript objects.
Column
width400px

On This Page:

Table of Contents
maxLevel3

...

 Here is an example of a query using the key to identify the Google sheet. Note the worksheet name and query string are passed as query parameters:

 Image RemovedImage Added

The query=<query string> parameter is where you specify which rows to match based on the data in your spreadsheet.

Warning

Variables in rules must be unique. Having duplicate variables in the same rule will cause the rule to fail but you may not get an error message.e

Queries using the Spreadsheet and Worksheet Name

...

 The image shows a query that reads from a Google sheet named Google Connector Address Sheet and a worksheet (tab) named Sheet1.  

 

Warning

The column name on a Google sheet must match the control name. The matching is case-insensitive and any spaces in the column name are ignored. A control named "FirstName" matches a column header "first name." However, references to Google Sheet columns in your rule must be lower case and cannot contain spaces. The correct reference for this example is "firstname."

Control NameColumn HeaderColumn Header in Rule
FirstNamefirst namefirstname

...