...
| Info |
|---|
First, it’s important to note that Google Sheets is not a transactional system like a database and results can be unpredictable if multiple users update the same Sheet at the same time. |
Step 1: Obtain an access token
As before, you have to first get an access token. This is a one-time step.
Open your web browser and login to your Google Account
Go to:
Live Forms Online Cloud customers: https://app.frevvo.com/google/consent
- Live Forms In-house customers: http://<your frevvo server domain name>/google/consent
- Copy and Save the access token. THIS IS VERY IMPORTANT. The token is used as the password for wizards and rules.
Click on the Accept button.
Step 2: Add the Business Rule
We’ve created a simple example form. Select the employee, a location and a new extension number. Click the Update Google Sheet button, wait a few seconds and see that the sheet was successfully updated. We did this using this rule:
...