Just to recap, i am a project manager, please do not expect me to reveal secret recipes how to do certain things, actual coding. However i will link those items which needs to be considerable.
So if you works for an entity not having strict security rules, then the most obvious choice is Google Docs. I am not talking Google Apps for Work, just a pure Google document with extra script added.
There are two projects i would like to reveal as possible hint:
Simple resource management tool
(i am really into Resource Mgmt as you will see.)
Different sheets represent demand entities (aka project manager). Columns are the resources and rows are the days to come.
Each PM adds his/her wishes (resource requests) to a certain day for a certain resource. And a script comb it together to reveal the collisions for the resource coordination meeting.
Thanks to Google. Very simple, easily accessible.
Though it is not really sofisticated, it can do the grunt work if that is all you need.
Sport game calendar
In some way it is also a resource mamagement tool. Guys can check in for certain gamedays. Also the paid in money is tracked in a different sheets.
And the spreadsheet automatically counts the personal balance based on the presence.
No trick here. We still use it.
The script can add the spice here as well.
Sportmates are usually too lazy to go online to check a spreadsheet, look for their name and the appropriate day and set their status to 'Participate'.
So why not let the script to send a reminder mail.
Still very simple and it runs once a week, but with this we have not solved the original problem of laziness.
So here comes the GMailApp, which lets you to read all emails in a specific gmail account.
Having said that those lazy sportmate only need to press a reply without any typing to let the script update their presence for a certain gameday. :-)
Code snippet to iterate thru mails with a certain subject (here they are dates):
var searchString = 'subject:(*' + Utilities.formatDate(utcDate, "GMT", "yyyy/MMM/dd") + ') OR (*' + Utilities.formatDate(tomorrow, "GMT", "yyyy/MMM/dd") + ')';
var threads = GmailApp.search(searchString);
for (var i = 0; i < threads.length; i++) {
var messages = threads[i].getMessages();
for (var j = messages.length - 1; j >= 0; j--) {
Stay tune, next time we jump into the possibilites how you can automate things at enterprise level....
