On this page:
Table of Contents
...
If you use the Doc Action Wizard to Send Data to Google Sheet, your Checkbox (multi-select) controls, repeat controls, and tables will pass to the spreadsheet as a comma space separated list. However, if you are passing those values using a business rule to update the Google Sheet, you may see it populate the sheet in error, such as "[Ljava.lang.String;@43156d18". The best way to correct this is to add some standard javascript to your rule to join the array into a string, such as this:
...
When using a T/F boolean control, by default the connector will pass the value "true" when checked and will pass no value (blank) when unchecked. To ensure that the value "false" is passed to your Google Sheet when the control is unchecked, simply check the "Required (false)" property on the properties panel for that control.
"Unknown Error has Occurred" message when logging on to the Save to Google Spreadsheet wizard
...
This may be because you are using an invalid or revoked access token in your business rule. Make sure you are using a valid access token and retest.
This error can also occur if you are writing to a Google Sheet using a business rule, and you have a text or textarea control that gets a value with a comma at runtime. For example, if you are passing a control in the var updateparams rule such as "FullName" and the runtime value entered is "Smith, John" the comma can interfere with the comma-separated update parameters being passed to the Google Sheet. This will be fixed in a future release. A workaround is to add code to your rule to strip the commas:
| Code Block |
|---|
//Remove Commas
var t = FullName.value;
var tcomma = t.replace(/,/g," "); |
Then, pass the variable "tcomma" in the updataparams rule instead of the original control value.
Invalid String Literal
If you see the error "invalid string literal" when using a business rule to read or update a google sheet, make sure that you have commented out the slashes in your oAuth Code, as in OAuth21\/\/0dqqBnY...
...