How to write a script to enable links in Google Docs (google apps)?

Question

Can anyone help me to answer my question?
I can write a link to Google docs with a script, but I don't know how to link that URL.
I want to enable to link "tmpURL" in the following example.

  var rowsData =  [
                    ['titleA', 'URL'], 
                    ['AAA', tmpURL]
                  ];

  table = body.appendTable(rowsData);
  table.getRow(0).editAsText().setBold(true);

Thanks.

Tanaike · Accepted Answer · 2021-06-06 05:30:39Z

2

I believe your goal as follows.

You want to append a table and you want to set the hyperlink to the column "B" of the table. The URL is the same with the text in the cell.
You want to achieve this using Google Apps Script.

In this case, how about the following modification?

Modified script:

var body = DocumentApp.getActiveDocument().getBody();
var tmpURL  = "###"; // Please set the URL.

var rowsData = [
  ['titleA', 'URL'],
  ['AAA', tmpURL],
];
table = body.appendTable(rowsData);
table.getRow(0).editAsText().setBold(true);
var text = table.getCell(1, 1).editAsText();
text.setLinkUrl(text.getText());

In this modification, the column "B" of the row 2 has the hyperlink.

When you want to reflect the hyperlink of the column "B", you can also the following script. In this script, even when the number of rows is more than 2, the column "B" has the hyperlink.

  var body = DocumentApp.getActiveDocument().getBody();
  var tmpURL  = "###"; // Please set the URL.

  var rowsData = [
    ['titleA', 'URL'],
    ['AAA', tmpURL],
  ];
  table = body.appendTable(rowsData);
  table.getRow(0).editAsText().setBold(true);
  var rows = table.getNumRows();
  for (var r = 1; r < rows; r++) {
    var text = table.getCell(r, 1).editAsText();
    text.setLinkUrl(text.getText());
  }

References:

answered Jun 6, 2021 at 5:30

Tanaike

203k12 gold badges126 silver badges222 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

buzzlyhan Over a year ago

Wow! So quick reply. I feel correct your script but I'm going to report result after test. anyway, Thanks!

buzzlyhan Over a year ago

Thanks a million! I tested the first one that from your script. That's correct! I knew "setLinkUrl" but I can't modify it well. I learned it. Thanks!

Tanaike Over a year ago

@buzzlyhan Thank you for replying and testing it. I'm glad your issue was resolved. Thank you, too.

Collectives™ on Stack Overflow

How to write a script to enable links in Google Docs (google apps)?

1 Answer 1

Modified script:

References:

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Modified script:

References:

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related