登録日時を追加

const SF_member = Sheet_Member.getSheetByName("memberspec");

function jointo(prop, event, replyToken, lc) {
 var lastRow = SF_member.getLastRow();
 var wordList = SF_member.getRange(1, 1, lastRow, 1).getValues();
 for (var i = 1; i < wordList.length; i++) {
   if (wordList[i][0] === event.source.userId) {
     lc.replyMessage(replyToken, [{ type: 'text', text: '登録済みです。' }]);
     return;
   }
 }
 var now = new Date();
 var time = Utilities.formatDate(now, 'Asia / Tokyo', 'yyyy/MM/dd HH:mm:ss');
 const user_prof = lc.getProfile(event.source.userId);
 var set_values = [[time, user_prof.userId, user_prof.displayName, user_prof.statusMessage, user_prof.pictureUrl]];
 SF_member.insertRows(2, 1);
 SF_member.getRange(2, 1, 1, set_values[0].length).setValues(set_values);
}

いいなと思ったら応援しよう!