Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...