Skip to content Skip to sidebar Skip to footer

Google Apps Script Problem Using Getlinkurl(offset)

I'm trying to figure out how to use getLinkUrl(offset) in Google Apps Script. I found the reference here - http://googlescriptreference.com/Document/Text/getlinkurloffset/, but I

Solution 1:

I was attempting to use the getLinkUrl(offset) directly on the paragraph element (not working example), but I needed to use asText() method before getLinkUrl(offset).

NOT Working

var paragraphText = paragraph.getLinkUrl(2);

Working

var paragraphText = paragraph.asText().getLinkUrl(2);

Google Documenthttps://docs.google.com/document/d/136G549zIYPYBndXs70ZnR_wEFg5fPST9ZGsOlTgmDyM/edit

//Works if link is on a word or words instead of entire paragraphfunctionmyFunctionP1() {
  //Find out how many Children there arevar body = DocumentApp.getActiveDocument().getBody();
  Logger.log(body.getNumChildren());

  //Find out which child is tablevar table = body.getChild(2); //table is child#2
  Logger.log(table);

  //Find tableCell inside of tablevar tableCell = table.getChild(0).getChild(0); //tableCell
  Logger.log(tableCell)

  //Find paragraph inside of tableCell //I think, but I'm not sure, the HYPERLINK will be found somewhere within the PARAGRAPH element. But I can't figure out how to get to it.var paragraph = tableCell.getChild(0); //paragraph element
  Logger.log(paragraph)

  //Get paragraph text var paragraphText = paragraph.asText().getLinkUrl(2); //paragraph text
  Logger.log(paragraphText)


}



//Works if link is on entire paragraph//Works if link is on entire paragraph//Works if link is on entire paragraphfunctionmyFunctionP2() {
  //Find out how many Children there arevar body = DocumentApp.getActiveDocument().getBody();
  Logger.log(body.getNumChildren());

  //Find out which child is tablevar table = body.getChild(4); //table is child#2
  Logger.log(table);

  //Find tableCell inside of tablevar tableCell = table.getChild(0).getChild(0); //tableCell
  Logger.log(tableCell)

  //Find paragraph inside of tableCell //I think, but I'm not sure, the HYPERLINK will be found somewhere within the PARAGRAPH element. But I can't figure out how to get to it.var paragraph = tableCell.getChild(0); //paragraph element
  Logger.log(paragraph)

  //Get paragraph text var paragraphText = paragraph.getText(); //paragraph text
  Logger.log(paragraphText)

  //Get HYPERLIINK from paragraph text var paragraphHYPERLINK = paragraph.getLinkUrl(); //paragraph text
  Logger.log(paragraphHYPERLINK)  

}

@Tanaike helped me find this solution. https://stackoverflow.com/users/7108653/tanaike

Post a Comment for "Google Apps Script Problem Using Getlinkurl(offset)"