function doGet(e) {return message("Error: no parameters in doGet"); }
function doPost(e) { if (!e.parameters.filename || !e.parameters.file || !e.parameters.imageformat) { return message("Error: Bad parameters in doPost"); } else { var imgf = e.parameters.imageformat[0].toUpperCase(); var mime = (imgf == 'BMP') ? MimeType.BMP : (imgf == 'GIF') ? MimeType.GIF : (imgf == 'JPEG') ? MimeType.JPEG : (imgf == 'JPG') ? MimeType.JPEG : (imgf == 'PNG') ? MimeType.PNG : (imgf == 'SVG') ? MimeType.SVG : false; if (mime) { var data = Utilities.base64Decode(e.parameters.file, Utilities.Charset.UTF_8); var blob = Utilities.newBlob(data, mime, e.parameters.filename); DriveApp.getFolderById('FOLDER ID HERE').createFile(blob); return message("Success"); } else { return message("Error: Bad image format"); } }}
function message(msg) { return ContentService.createTextOutput(JSON.stringify({Result: msg })).setMimeType(ContentService.MimeType.JSON);}
function doGet(e){ var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/"sheet_ID"/edit#gid=0"); var sheet = ss.getSheetByName("Sheet1"); addReport(e,sheet); }
//if you are using doPost / post methods in your clientfunction doPost(e){ var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/"sheet_ID"/edit#gid=0"); var sheet = ss.getSheetByName("Sheet1"); addReport(e,sheet); }
function addReport(e,sheet) { var equipment = e.parameter.equipment; var area = e.parameter.area; var type = e.parameter.type; var points = e.parameter.points; var location = e.parameter.location; var date = e.parameter.date; var wo = e.parameter.wo; var comments = e.parameter.comments; var actions = e.parameter.actions; sheet.appendRow([equipment,area,type,points,location,date,wo,comments,actions]); }
var imageID = DriveApp.getFolderById('FOLDER ID HERE').createFile(blob).getId();
function doGet(e) {return message("Error: no parameters in doGet"); }
function doPost(e) { if (!e.parameters.filename || !e.parameters.file || !e.parameters.imageformat) { return message("Error: Bad parameters in doPost"); } else { var imgf = e.parameters.imageformat[0].toUpperCase(); var mime = (imgf == 'BMP') ? MimeType.BMP : (imgf == 'GIF') ? MimeType.GIF : (imgf == 'JPEG') ? MimeType.JPEG : (imgf == 'JPG') ? MimeType.JPEG : (imgf == 'PNG') ? MimeType.PNG : (imgf == 'SVG') ? MimeType.SVG : false; if (mime) { var data = Utilities.base64Decode(e.parameters.file, Utilities.Charset.UTF_8); var blob = Utilities.newBlob(data, mime, e.parameters.filename);
var image = DriveApp.getFolderById('FILE_ID').createFile(blob); var linkID = image.getId(); var sheet = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/SHEET_ID/edit?usp=sharing").getSheetByName("Sheet1"); addReport(e,sheet);
return message("Success"); } else { return message("Error: Bad image format"); } }}
function addReport(e,sheet) { var equipment = e.parameter.equipment; var area = e.parameter.area; var type = e.parameter.type; var points = e.parameter.points; var location = e.parameter.location; var date = e.parameter.date; var wo = e.parameter.wo; var comments = e.parameter.comments; var actions = e.parameter.actions;
var time = e.parameter.time; var status = e.parameter.status; var link = e.linkID; sheet.appendRow([time,status,equipment,area,type,points,location,date,wo,comments,actions,link]);
function doGet(e) { return message("Error: no parameters in doGet"); }
function doPost(e) { if (!e.parameters.filename || !e.parameters.file || !e.parameters.imageformat) { return message("Error: Bad parameters in doPost"); } else { var imgf = e.parameters.imageformat[0].toUpperCase(); var mime = (imgf == 'BMP') ? MimeType.BMP : (imgf == 'GIF') ? MimeType.GIF : (imgf == 'JPEG') ? MimeType.JPEG : (imgf == 'JPG') ? MimeType.JPEG : (imgf == 'PNG') ? MimeType.PNG : (imgf == 'SVG') ? MimeType.SVG : false; if (mime) { var data = Utilities.base64Decode(e.parameters.file, Utilities.Charset.UTF_8);
var blob = Utilities.newBlob(data, mime, e.parameters.filename);
//get the image file ID like this: var imageID = DriveApp.getFolderById('1gTB0ABCs2gpqYpBGSFx3nyTZ0QzZbtyZ').createFile(blob).getId();
//append the ID to your spreadsheet like this: var ss = SpreadsheetApp.openById('1fDJ7_oj4JAR3l2uljghlW2rcpJYiA8rnD7uPgKc0QjI'); var sh = ss.getSheets()[0]; sh.appendRow([imageID]);
return message("Success"); } else { return message("Error: Bad image format"); } }}