On this page:
...
This error can also occur if you are writing to a Google Sheet using a business rule using the deprecated '&updates' parameter, 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. To correct this, please update your business rule to use the '&updatesjson' parameter as described in this documentation.
Alternatively, you may 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...
...