如何在Google Sheets弹窗中显示可点击的Drive文件链接？

Hey there! Nice job getting your script up and running so quickly as a new programmer—let's tweak it to make that file URL a clickable link in your modal dialog.

The Issue #

Right now, you're passing the raw URL string directly to HtmlService.createHtmlOutput(), which just displays it as plain text. To make it clickable, we need to wrap the URL in an HTML <a> (anchor) tag.

Modified Code #

Here's your updated script with the fix (I've highlighted the key change):

function applicationcreator() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var database = ss.getSheetByName("Database");
  var rowname = database.getActiveCell().getRow();
  var name = database.getRange(rowname, 4).getValue(); // Changed getValues() to getValue() for single cell data
  var ss2 = SpreadsheetApp.create("Resume");
  var skill = ss2.getSheetByName("Sheet1");
  var url = ss2.getUrl();
  var form = ss.getSheetByName("Profilegenerator");
  var copy = form.copyTo(ss2);
  var form2 = ss2.getSheetByName("Copy of Profilegenerator").setName("Resume " + name);
  
  // Key fix: Wrap URL in an HTML anchor tag to make it clickable
  var htmlOutput = HtmlService
    .createHtmlOutput('<a href="' + url + '" target="_blank">Open Your New Resume File</a>')
    .setWidth(250)
    .setHeight(50);
  
  SpreadsheetApp.getUi().showModalDialog(htmlOutput, 'Employee Profile');
}

Quick Notes on the Changes: #

• Clickable Link: The <a href="' + url + '" target="_blank">...</a> creates a clickable link that opens the file in a new browser tab (thanks to target="_blank"), so users don't lose their place in the spreadsheet.
• getValue() instead of getValues(): Since you're pulling data from a single cell, getValue() returns a clean string instead of a 2D array—this prevents odd formatting in your file name.
• User-Friendly Text: Instead of showing the messy raw URL, we use descriptive text like "Open Your New Resume File" which is easier for users to understand.

How It Works #

When you pass HTML to createHtmlOutput(), the HtmlService renders it as a proper web element—so the anchor tag gets recognized as a clickable link instead of plain text.

内容的提问来源于stack exchange，提问作者saul velasquez