...
...
...
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.
...
...
| width | 400px |
|---|
...
On This Page:
| Table of Contents | ||
|---|---|---|
|
Google Connector Query and Path Parameters
...
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."
|
...