希望有人可以提供帮助。
我们使用Google表单中的联系表单。我们使用Trello来处理它们。 我已使用代码将输入从Google表单发送到trello卡。
现在,我想添加一个可单击的按钮或指向卡片说明的链接,这将打开电子邮件客户端并插入“ mailto”,“ subject”和“ body”。 mailto和body应该是变量(来自表格的输入)。 “正文”是客户通过表格发送给OS的输入信息和消息。
如果将“正文”的格式设置为“引用”,就好比您要答复发送表单的客户,那将是非常好的。但是我不知道那是否有可能。
我是编码新手...:-)
function onFormSubmit(e) {
createTrelloCard(e.range);
function createTrelloCard(range) {
var TrelloKey = "...";
var TrelloToken = "...";
var TrelloList = "...";
var label1 = '...';
var values = range.getvalues();
var column = values[0];
var timestamp = column[0];
var ordrenr = column[1];
var email = column[2];
var firma = column[3];
var telefon = column[4];
var besked = column[5];
var cardName = firma + "\xa0" + "Ordrenr. " + ordrenr;
var cardDesc = "\n" + email + "\n\n" + "**Telefon **" + telefon + "\n\n" + besked;
var footer = "\n\n" + "**Submitted on: **" + timestamp;
cardDesc = cardDesc + footer;
var labels = label1;
//*****************************************************
//****** DO NOT CHANGE ANYTHING BELOW THIS LINE *******
//*****************************************************
//Send POST payload data via Trello API
//POST [/1/cards],Required permissions: write
var payload = {"name":cardName,"desc":cardDesc,"pos":"bottom","due": "",//(required) A date,or null
"idList":TrelloList,//(required) id of the list that the card should be added to
"idLabels":labels,};
//Because payload is a JavaScript object,it will be interpreted as an HTML form
var url = "https://api.trello.com/1/cards?key=" + TrelloKey + "&token=" + TrelloToken + "";
var options = {"method" : "post","payload" : payload};
UrlFetchApp.fetch(url,options);
}
}