frevvo Latest - This documentation is for frevvo v10.0. Not for you? Earlier documentation is available too.
Let's take a look at how you can update existing values in a sheet. It’s another common scenario that can be used for a variety of tasks (e.g. limiting the number of submissions for a particular form or creating a sequentially increasing counter). We’ll use this sample Google Sheet to discuss. It has a row for each employee: Employee Id, Location and Extension.
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.
On This Page:
If you do not have an access token for your Google Account, perform this one time step.
Follow these steps to obtain your Google Account token. Login to your Google Account Go to: Cloud customers: https://app.frevvo.com/google/consent Click Allow if you see a screen like the one below (Google often updates their UI so this may differ from what you see). Copy the access token. Save it to a safe location, you will use it when configuring your forms/workflows.
Login to your Google Account
Cloud customers: https://app.frevvo.com/google/consent
Click Allow if you see a screen like the one below (Google often updates their UI so this may differ from what you see).
Copy the access token. Save it to a safe location, you will use it when configuring your forms/workflows.
Escape the slash characters in your OAuth token with a backslash in the rule below like this: OAuth21\/\/<###...>
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:
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."
If your rules were developed with a Google Connector prior to v3.0.5, they used the parameter '&updates=' followed by the concatenated column names and control values, such as:
This method is still supported, however it is no longer best practice. When using this method with text or textarea controls, you will find that if the user enters characters such as a comma or equals sign, the rule will encounter an error. Consider using the '&updatesjson=' method described above for the most reliable behavior.