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.
...
| Warning |
|---|
|
...
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."
|
...