...
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 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 a hidden text control some standard javascript to your form and then use a business rule to get the value(s) of the selection or repeat control, like join the array into a string, such as this:
Code Block |
---|
var list = ''; for (var a = 0; a <// Join the array value of MultiCheck into a space-separated string. var mcj = MultiCheck.value.length; a++) { var j = mcj.join(' '); list =// listPass + MultiCheck[a].value + ' '; } MCList.value = list; |
...
the variable 'j' to the Google Sheet.
var updateparams = '&updates='+encodeURIComponent('multicheck='+j+); |
"Unknown Error has Occurred" message when logging on to the Save to Google Spreadsheet wizard
...