Google Script Invalid Assignment left-hand side
Google Script Invalid Assignment left-hand side
好的,我有了这段代码。对不起,我不知道问题在哪里,所以我都粘贴了。左边是无效赋值。(第1行,文件"Code")。我知道问题不可能在一号线,但我不知道它在哪里。
function send(sheet, email, row){
var tmp = GmailApp.getAliases();
var alias = tmp[0];
var subject = "Thank you for signing up for "+ sheet.getSheetName()+ "!";
var body = "Hello "+ sheet.getRange(row,3).getValue() + " " + sheet.getRange(row,4).getValue() + "," + ''n'+''n';
var temp = 2;
var bool = "TRUE";
while (bool == "TRUE"){
if (sheet.getRange(temp,11).getValue() != ''){
body += ''n' + sheet.getRange(temp,11);
temp += 1;
}
if (sheet.getRange(temp + 1,11).getValue() != '')
body += ''n' + body += ''n' + sheet.getRange(temp + 1,11);
else {bool = "FALSE"}
}
Logger.log(body);
if ( sheet.getRange('L2').getValue() != ""){
var html = sheet.getRange('L2').getValue(); // Place HTML code here
try {
GmailApp.sendEmail(email, subject, body, {'from': alias, 'htmlbody': html});
sheet.getRange(row, 9).setBackground("green");
sheet.getRange(row, 9).setValue("Yes");
sheet.getRange("J2").setValue(row - 2);
} catch (e) {
var me = Session.getActiveUser().getEmail();
MailApp.sendEmail(me, "Autoreply error", "There was a problem sending an email to: " + email +".");
}
}
else{
try {
GmailApp.sendEmail(email, subject, body, {'from': alias});
sheet.getRange(row, 9).setBackground("green");
sheet.getRange(row, 9).setValue("Yes");
sheet.getRange("J2").setValue(row - 2);
} catch (e) {
MailApp.sendEmail(me, "Autoreply error", "There was a problem sending an email to: " + email +".");
}
}
}
function main(){
var ss = SpreadsheetApp.openById("1a2xvZ6hx69hst0CoLnCc8V5Igi-V5_HaNm6GTpEU8B4"); // Unique ID for the 'Responses' spreadsheet
var sheet = ss.getActiveSheet();
if ( sheet.getRange('J2').getValue() == "" ){
sheet.getRange('I1').setValue("Sent"); // Initialize labels
sheet.getRange('J1').setValue("Count");
sheet.getRange('K1').setValue("Email body");
sheet.getRange('L1').setValue("HTML body");
var row = 2;
} else {
var row = sheet.getRange("J2").getValue() + 2;
}
while ( (sheet.getRange(row,9).getValue() != '') && (sheet.getRange(row,2).getValue() != '')) {
var email = sheet.getRange(row, 2).getValue();
send(sheet, email, row);
row += 1;
}
}
不能这样写:(2 x +=
在同一语句中)
body += ''n' + body += ''n' + sheet.getRange(temp + 1,11); // this throws the error
我建议使用这样的中间变量:
var xxx = ''n' + sheet.getRange(temp + 1,11);
body+= ''n'+ body + xxx ;
如果这真的是你想做的…但我觉得很奇怪……
应该是这样的:body+= ''n'+sheet.getRange(temp + 1,11);
相关文章:
- margin-left和width属性在mozillafirefox中不起作用
- Div and ul list side by side
- Two input forms side-by-side programatically via JavaScript
- Javascript if statement if (ball.style.left === '0px'
- 从jQuery变量中提取数据,增加's left,将剥离的数据放回变量中
- JavaScript: var {left, ...props} = this.props;
- 尝试使 the_image.style.left = x_position;但日志显示结果不相等
- Javascript viewport then element.style.left 不起作用?这有什么问题
- XSRF with AngularJS: DocuSign API Embedded View Client-Side
- “Math.abs(parseInt($(this).css('left')”返回与预期不同的值
- Javascript style.left 是空字符串
- 如何使用 style.left 从右向左移动图像
- jQuery Uncaught TypeError with offset().left
- 无法更新返回的元素.style.left,为什么
- 获取未捕获的类型错误:无法读取 js 中 null 的属性“left”
- Rails Gem Client Side Validations html struct
- scrollLeft: to END OF MAIN DIV not offset().left
- Jquery offset().left和position().lift返回意外值
- 如何处理'无效赋值left hand '错误:firefox或chrome
- Google Script Invalid Assignment left-hand side