| Section |
|---|
| Column |
|---|
business rules are used to retrieve and update data in Google sheets via the Google Connector. One advantage to initializing your form/flow 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/flow 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.
|
|
...
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 Name | Column Header | Column Header in Rule |
|---|
| FirstName | first name | firstname |
|
...
