[为避免误解和毫无根据的指控而编辑]我正在使用谷歌脚本开发一个短期住房的预订系统。因此，当有人提交表格时，他们会收到修改后的确认电子邮件，以及一个带有编辑响应URL的按钮。工艺流程：
- 有人，让我们叫他A提交了一份表格
- 在工作表上生成编辑响应URL
- 生成的URL发送到A的包含编辑响应URL的电子邮件
如何从表单提交中分配生成的编辑响应URL，然后将其分配给确认电子邮件中的按钮？提前谢谢！
//Email main template
function draftEmail(request){
//generate edit URL into spreadsheet
var formRes = FormApp.openById('form id'); //
var sheetRes = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('sheet name');
var data = sheetRes.getDataRange().getValues();
var urlCol = 11;
var responses = formRes.getResponses();
var timestamps = [], urls = [], resultUrls = [];
for (var i = 0; i < responses.length; i++) {
timestamps.push(responses[i].getTimestamp().setMilliseconds(0));
urls.push(responses[i].getEditResponseUrl());
}
for (var j = 1; j < data.length; j++) {
resultUrls.push([data[j][0]?urls[timestamps.indexOf(data[j][0].setMilliseconds(0))]:'']);
}
sheetRes.getRange(2, urlCol, resultUrls.length).setValues(resultUrls);
//button link --> I want to assign the link generated from function above, and then assign it to buttonlink below
request.buttonLink = 'LINK TO EDIT RESPONSE URL GENERATED FROM ABOVE FUNCTION';
request.buttonText = "Reschedule";
switch (request.status) {
case "Approve":
request.subject = "Confirmation: " + request.room + " Reservation for " + request.dateString;
request.header = "Confirmation";
request.message = "Your room reservation has been scheduled. Total payment: " + request.total + " JPY";
break;
case "Conflict":
request.subject = "Conflict with " + request.room + "Reservation for " + request.dateString;
request.header = "Conflict";
request.message = "There is a scheduling conflict. Please pick another room or time."
request.buttonText = "Reschedule";
break;
}
}
这是电子邮件.gs部分
function makeEmail(request) {
return (
'<!DOCTYPE html><html><head><base target="_top"></head><body><div style="text-align: center;' +
'font-family: Arial;"><div id="center" style="width:300px;border: 2px dotted grey;background:' +
'#ececec; margin:25px;margin-left:auto; margin-right:auto;padding:15px;"><img src="https://upload.' +
"" +
'.svg.png"width="180" style="margin:10px 0px"><br /><div style=" border: 2px dotted grey;' +
'background:white;margin-right:auto; margin-left:auto; padding:10px;"><h2>' +
request.header +
"</h2><h3>" +
request.message +
"<br /><br/>" +
request.name +
"<br />" +
"AMS Room " + request.room +
"<br />" +
"Check-in: " + request.dateString +
"<br />" +
"Check-out: " + request.dateOutString+
"<br /></h3><br />" +
'<a href="' +
request.buttonLink +
'" class="btn" style="-webkit-border-radius: 28;' +
"-moz-border-radius: 5;border-radius: 5px;font-family: Arial; color: #ffffff;font-size: 15px;" +
'background: #ff7878;padding:8px 20px 8px 20px;text-decoration: none;">' +
request.buttonText +
'' +
);
}
这会接近您想要做的吗？这显示在可编辑的已提交表单的确认电子邮件中放置链接。如何从谷歌表单发送带有编辑URL的电子邮件？
这一步还将通过电子邮件向提交者发送编辑URL：https://webapps.stackexchange.com/questions/50009/is-there-a-way-to-keep-track-of-the-url-used-to-edit-responses-in-google-form
这里还有一个关于用户编辑回复的谷歌支持线程。第五条评论还有一个指向某些脚本的链接：https://support.google.com/docs/thread/9968940?hl=en
编辑：这篇文章出现在页面右侧的相关链接中，以防您在确保电子邮件发送前生成URL时遇到任何问题：谷歌表单。确认电子邮件脚本。带有编辑url
感谢大家的帮助！！！归功于@Micah。实际上，我的问题是如何在谷歌表单的单元格中分配一个URL，然后将其分配给一个按钮作为URL，下面这行就像一个符咒！=resultUrls[resultUrls.length-1]；
//Email main template
function draftEmail(request){
//generate edit URL into spreadsheet
var formRes = FormApp.openById('form id'); //
var sheetRes = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('sheet name');
var data = sheetRes.getDataRange().getValues();
var urlCol = 11;
var responses = formRes.getResponses();
var timestamps = [], urls = [], resultUrls = [];
for (var i = 0; i < responses.length; i++) {
timestamps.push(responses[i].getTimestamp().setMilliseconds(0));
urls.push(responses[i].getEditResponseUrl());
}
for (var j = 1; j < data.length; j++) {
resultUrls.push([data[j][0]?urls[timestamps.indexOf(data[j][0].setMilliseconds(0))]:'']);
}
sheetRes.getRange(2, urlCol, resultUrls.length).setValues(resultUrls);
//button link --> I want to assign the link generated from function above, and then assign it to buttonlink below
request.buttonLink = = resultUrls[resultUrls.length - 1];
request.buttonText = "Reschedule";
switch (request.status) {
.
。。}