将存储为变量的URL转换为Google Apps脚本文件中JSON负载中的href

Question

我有一个谷歌应用程序脚本，它本质上是通过Slack将谷歌表单中的关键信息发送给我，其中一条是表单的URL，存储为以下变量：

var sheetUrl = ss.getUrl();

我调用JSON负载中的"sheetUrl"变量，然后运行下面的函数：

function sendToSlack_(url,payload) {
var options =  {
"method" : "post",
"contentType" : "application/json",
"payload" : JSON.stringify(payload)
};
return UrlFetchApp.fetch(url, options)
}

我想把这个"表单URL"转换成HREF，而不是发布整个谷歌表单URL，因为它又丑又长，有人能给我指明正确的方向吗？

这是一个精简版的脚本文件，提供上下文：

function sendToSlack() {
var url = "https://hooks.slack.com/services/"; // channel in Slack  
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheetUrl = ss.getUrl();
var stagingData = ss.getSheetByName('Staging');
//Week No for current week & previous week
var currentWeekNo = stagingData.getRange(2, 6).getValue();
var previousWeekNo = stagingData.getRange(1, 6).getValue();

// Quantities for current week vs Previous Week
var sv15CurrentWeek = stagingData.getRange(6, 15).getValue();
var sv15BasicCurrentWeek = stagingData.getRange(7, 15).getValue();
var sv15BgCurrentWeek = stagingData.getRange(8, 15).getValue();
var sv156CurrentWeek = stagingData.getRange(9, 15).getValue();
var sv15PreviousWeek = stagingData.getRange(20, 15).getValue();
var sv15BasicPreviousWeek = stagingData.getRange(21, 15).getValue();
var sv15BgPreviousWeek = stagingData.getRange(22, 15).getValue();
var sv156PreviousWeek = stagingData.getRange(23, 15).getValue();


function formatNumber(num) {
return num.toFixed(2).replace(/(d)(?=(d{3})+(?!d))/g, '$1,')
}

var payload = {
"channel" : "#reports",
"type": "mrkdwn",
"text" : 
"*Week No. * - " + currentWeekNo + " vs " + previousWeekNo + "n " 
+ "n " 
+ sheetUrl
}

{
sendToSlack_(url,payload)
}
function sendToSlack_(url,payload) {
var options =  {
"method" : "post",
"contentType" : "application/json",
"payload" : JSON.stringify(payload)
};
return UrlFetchApp.fetch(url, options)
}
}

Answer 1

现在可以包装锚点，并在加号之间包含变量，如下所示

"lt"+sheetUrl+"|链接>quot；