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:
...
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...
...