Create Google Form
Code Google Form to LINE Notify
// Presented by BrilliantPy.com
function sendLineNotify() {
// Editable
var form = FormApp.openById('xxxx Google Form ID xxxx');
var tokens = ['xxxx LINE Token xxxx']; // For 1 line group
//var tokens = ['WNFKVX1uXhfAqwLCIPxHiAWNFKVX1uXhfAqwLCIPxHiA','WNFKVX1uXhfAqwLCIPxHiAWNFKVX1uXhfAqwLCIPxHiA']; // For multiple line groups
// Init
var form_res = form.getResponses()
var formResponse = form_res[form_res.length - 1];
var itemResponses = formResponse.getItemResponses();
// Gets an array of all items in the form.
var items = form.getItems();
var all_message = form.getTitle() + '\n';
var all_message_resend = '';
var all_message_send = '';
var image_id = [];
var IMAGE_URL = [];
var imgThumbnail = [];
var imgFullsize = [];
var file_upload_num = 0;
for (var i = 0; i < itemResponses.length; i++)
{
if (itemResponses[i].getItem().getType() == "GRID")
{
var mrow = items[i].asGridItem().getRows();
var mcol = items[i].asGridItem().getColumns();
var itemResponse_val = itemResponses[i].getResponse().toString().split(",")
all_message += (i+1) + ') ' + itemResponses[i].getItem().getTitle() + ' : ' + '\n';
for (var j = 0; j < mrow.length; j++)
{
all_message += ' - ' + mrow[j] + ' : ' + itemResponse_val[j] + '\n';
}
}
else if (itemResponses[i].getItem().getType() == "FILE_UPLOAD")
{
image_id[file_upload_num] = itemResponses[i].getResponse()
IMAGE_URL[file_upload_num] = 'https://drive.google.com/uc?export=view&id='+ image_id[file_upload_num];
imgThumbnail[file_upload_num] = IMAGE_URL[file_upload_num]; // 240×240px JPEG
imgFullsize[file_upload_num] = IMAGE_URL[file_upload_num]; //1024×1024px JPEG
//all_message += (i+1) + ') ' + itemResponses[i].getItem().getTitle() + ' : ' + 'As below' + '\n';
all_message += (i+1) + ') ' + itemResponses[i].getItem().getTitle() + ' : ' + IMAGE_URL[file_upload_num] + '\n';
file_upload_num += 1;
}
else
{
all_message += (i+1) + ') ' + itemResponses[i].getItem().getTitle() + ' : ' + itemResponses[i].getResponse() + '\n';
}
}
all_message_send = all_message;
for (var k = 0; k < tokens.length; k++) {
if ( file_upload_num > 0 )
{
for (var m = 0; m < file_upload_num; m++ )
{
if ( m == 0 )
{
all_message_send = all_message;
}
else if ( m > 0 )
{
all_message_resend = 'Picture: ' + (m+1);
all_message_send = all_message_resend;
}
var formData = {
'message' : all_message_send,
'imageThumbnail': imgThumbnail[m],'imageFullsize' : imgFullsize[m],
}
var options = {
"method" : "post",
"payload" : formData,
"headers" : {"Authorization" : "Bearer " + tokens[k]}
};
UrlFetchApp.fetch("https://notify-api.line.me/api/notify", options);
}
}
else {
var formData = {
'message' : all_message_send,
}
var options = {
"method" : "post",
"payload" : formData,
"headers" : {"Authorization" : "Bearer " + tokens[k]}
};
UrlFetchApp.fetch("https://notify-api.line.me/api/notify", options);
}
}
}
Code Google Sheet to Google Calendar
function meetingRoomBooking() {
//Set data from Spread Sheet
var spreadSheetID = "xxx Google Sheet ID xxx";
var ss = SpreadsheetApp.openById(spreadSheetID);
var sheet = ss.getActiveSheet();
var lastRow = sheet.getLastRow();
var lastColumn = sheet.getLastColumn();
/*
Logger.log(lastRow);
Logger.log(lastColumn);
*/
//Set data for Google Calendar
var topic = sheet.getRange(lastRow, 5).getValue();
var roomNumber = sheet.getRange(lastRow, 6).getValue();
var startDate = new Date(sheet.getRange(lastRow, 7).getValue());
var endDate = new Date(sheet.getRange(lastRow, 8).getValue());
/*
Logger.log("name:" + name);
Logger.log("Phone Number:" + phoneNumber);
Logger.log("Room Number:" + roomNumber);
Logger.log("Start Date:" + startDate);
Logger.log("End Date:" + endDate);
*/
//Creates a calendar event using the submitted data
var calendar = CalendarApp.getCalendarById("xxx Google Calendar ID xxx");
var titles = (topic + ' ' + '' + roomNumber);
var descriptions = roomNumber;
calendar.createEvent(titles, startDate, endDate, {description: descriptions});
}
NanoSoftTech
NanoSoftTech 