I need a way to replace part of a string with another string using Google Apps Script. I tested the following and it worked:

function test(){
  var value = '';
  var googleimageURL = googlePlus(value);
  Logger.log('Returned Result: ' + googleimageURL);
}

function googlePlus(value){
    var apiKey = ScriptProperties.getProperty('apiKey');
    var re = 'http://'
    var theURL = value;
    Logger.log('Google+ is called: ' + value);
    var replacingItem = 'https://';
    var theURL = theURL.replace(re, replacingItem);
    Logger.log('Google+ Values 2: ' + value + ' : ' + theURL + ' after ' + replacingItem);
    return imageURL;
}

But, when I embedded into the following code, it did not work. Any idea?

  //If a Google+ column was not specified,put a flag.
  if (googleColumn && column == googleColumn) {
    if (value == ""){
      columns.push(nogoogleColumn);
      values.push(flag);
      var googleimageURL="";
    } else {
      var googleimageURL = googlePlus(value);
      Logger.log('Returned Result: ' + googleimageURL);
    }
  }

The script did not work as I wish. It seems to stop at line:

var theURL = theURL.replace(re, replacingItem);

Additional information: Google notified me with the following message

onFormSubmit

TypeError: Cannot find function replace in object . (line 536) formSubmit

I need a way to replace part of a string with another string using Google Apps Script. I tested the following and it worked:

function test(){
  var value = 'https://plus.google./117520727894266469000';
  var googleimageURL = googlePlus(value);
  Logger.log('Returned Result: ' + googleimageURL);
}

function googlePlus(value){
    var apiKey = ScriptProperties.getProperty('apiKey');
    var re = 'http://'
    var theURL = value;
    Logger.log('Google+ is called: ' + value);
    var replacingItem = 'https://';
    var theURL = theURL.replace(re, replacingItem);
    Logger.log('Google+ Values 2: ' + value + ' : ' + theURL + ' after ' + replacingItem);
    return imageURL;
}

But, when I embedded into the following code, it did not work. Any idea?

  //If a Google+ column was not specified,put a flag.
  if (googleColumn && column == googleColumn) {
    if (value == ""){
      columns.push(nogoogleColumn);
      values.push(flag);
      var googleimageURL="";
    } else {
      var googleimageURL = googlePlus(value);
      Logger.log('Returned Result: ' + googleimageURL);
    }
  }

The script did not work as I wish. It seems to stop at line:

var theURL = theURL.replace(re, replacingItem);

Additional information: Google notified me with the following message

onFormSubmit

TypeError: Cannot find function replace in object https://plus.google./117520727894266469000. (line 536) formSubmit

• javascript
• google-apps-script
• triggers

1 Answer 1

I found the mistake. It is Type Error. value in the second block is not a "string", while the first block is a "string". Hence to fix the second block, I need to use:

var value = value.toString();

before passing to googlePlus(value)