Jasper Yu says to YSITD

while (sheet.getRange(row, 1).getValue() != ''){ //如果本列還有值 if (sheet.getRange(row, 1).getValue() == user_name && sheet.getRange(row, 5).getValue() == ''){ table_out += model.replace("項目", sheet.getRange(row, 3).getValue()).replace("金額", sheet.getRange(row, 2).getValue()).replace("截止日期", Utilities.formatDate(sheet.getRange(row, 4).getValue(), 'Asia/Taipei', 'yyyy-MM-dd')); } row++; }

at Wed, Dec 4, 2019 11:30 PM