...
Create a Google Sheet containing the customer address details. Make sure the column header names match the Name property of each control. The spaces in the Column Header will be ignored.
| Control Name | Column Header |
|---|---|
| CustomerName | customer name |
| FullAddress | full address |
| Street | street |
| City | city |
| ZipCode | zip code |
| Warning |
|---|
All references to Google Sheet columns in your rule MUST be lower case and cannot contain spaces. Google sheet column names must match Control Names exactly. Control Names cannot contain spaces, special characters or start with a number. |
Copy the Spreadsheet key to use in the Business Rule
...
The rule reads the number in the nextid column of the spreadsheet and populates the Checknum field in the form when the form loads. It then adds 1 and updates the nextid column in the spreadsheet. The Checknum field for the next user to load the form is populated with the incremented value.