Postbus
. In the folder Postbus
the files are renamed and send to a folder into which they belong. Almost all done by GAS-script(s).The new name of the file of a file contains a task if necessary:
case name-yymmdd-letter in tttyymmdd do something
A GAS-script collect the tasks and (1) send an email once a week with all the tasks and (2) send an email the day before a task has to be done. Since a week or so a GAS-script adds te tasks also to Google Tasks. I now can see the tasks in Google Calender which is very handy.function tasksToTasksList(){ var bestanden = DriveApp.searchFiles('title contains "ttt"'); while (files.hasNext()){ var file = files.next(); var fileName = file.getName(); var fileDescription = file.getDescription(); if(/ttt\d\d\d\d\d\d/.test(fileName) && /toTasksList/.test(fileDescription) ==false){ var taskDate = YYMMDD_TO_DATE(/\d\d\d\d\d\d/.exec(fileName.split(/ttt/)[1])); var caseName = fileName.split(/-\d{6}-/)[0]; var taskWhat = fileName.split(/ttt\d{6}/)[1].split(".")[0]; var timeZone = Session.getScriptTimeZone(); if(taskDate.getTime() >= (new Date).getTime()){ var task = { title: caseName + " " + taskWhat, due: Utilities.formatDate(taskDate,timeZone,"yyyy-MM-dd'T'HH:mm:ss'Z'") }; Tasks.Tasks.insert(task,hlptasksToTasksList()); file.setDescription("toTasksList_" + DATE_TO_YYMMDD(new Date())); } } } } function hlptasksToTasksList(){ var lists = Tasks.Tasklists.list().items; for(var i=0;i<lists.length;i++){ if(lists[i].title == NAME_TASKSLIST){ var idTasksList = lists[i].id; } } return idTasksList; } function YYMMDD_TO_DATE(yymmdd){ var dateString = yymmdd.toString(); var date = new Date(2000 + Number(datumstring.slice(0,2)),Number(dateString.slice(2,4))-1,Number(datumstring.slice(4,6))); return date; }
function DATE_TO_YYMMDD(date){ var timeZone = Session.getScriptTimeZone(); return Utilities.formatDate(new Date(datum),timeZone, "yyMMdd"); }
Sources:
Geen opmerkingen:
Een reactie posten