可以要求用户在FORM中写出他们的电子邮件地址,然后他们收到具有唯一编号的电子邮件吗?
我在这里找到了如何向发送者自动发送电子邮件-http: //www.labnol.org/internet/auto-confirmation-emails/28386/
但是不知道如何分别给他发送唯一的号码!
您可以尝试使用上面的代码来检索表单响应的唯一ID。但这不是排序的数字(1,2,...)。这是表单生成的唯一随机数。我的建议是不要尝试构建从1开始甚至更远的东西,因为它是异步的,因此您没有安全的排序项目列表。有关详情,请参见此处。
/**
* for a form with 2 question named "question 1" and "question 2"
* this function need to be associated directly to the form
* and it need to be associated to a trigger "on form submit"
* the "e" given as argument is generated by the form submit trigger
*/
function submitFormFunc(e) {
var items = e.response.getItemResponses();
var responses={};
for(var i = 0; i< items.length; i++) {
responses[items[i].getItem().getTitle()]=items[i].getResponse();
}
var responseTable = [];
var responseIndex = ["Timestamp","ID","question 1","question 2"];
responseTable.push(e.response.getTimestamp().toString());
responseTable.push(e.response.getId());
responseTable.push(responses["question 1"]); // my form have 2 questions named "question 1" and "question 2"
responseTable.push(responses["question 2"]);
responseTable.push(FormApp.getActiveForm().getResponse(e.response.getId()).getEditResponseUrl());
SpreadsheetApp.openById("YOUR_SPREADSHEET_ID").appendRow(responseTable);
}
- 编辑 -
如果您想缩短时间,可以使用时间戳记:
变化(或添加)responseTable.push(e.response.getTimestamp().toString());
为
responseTable.push(e.response.getTimestamp().getTime().toString());
甚至更短,但效率稍低:
您可以添加一行:
responseTable.push(generateUnique());
并添加功能:
function generateUnique(){
var vals = SpreadsheetApp.openById("YOUR_SPREADSHEET_ID").getRange("A:A").getValues();
var ids=[];
for(var i in vals){
ids.push(vals[0]);
}
var newId = Math.floor(Math.random()*100); // change 100 for something bigger if needed
while(ids.indexOf(newId)>-1){
newId = Math.floor(Math.random()*100);
}
Logger.log(newId);
return(newId);
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句