Tuesday, July 5, 2011

Never miss that damn meeting again(SMS reminder) !

How many times have you been derided for missing an 'important' meeting/call. or those of us who do not have a blackberry, the outlook reminders remain with us only for 8-9 hours. What about those meetings at midnight? on weekends? which we forever seem to forget? There is a cure:

We will set up Google calendar to send reminder SMS for the meetings which are synced to Google calendar from Outlook's calendar.

First, sign in to Google calendar at https://www.google.com/calendar using your gmail account. Go to settings=>mobile_setup and setup and activate your mobile number. 
Download and install Google calendar sync from here . You can read more about the sync app here . Sign into this application using the same Google account which you used to sign-in to Google calendar. Select the type of sync to be performed and the interval of sync.

Now comes a bit tricky part. Google doesn't enable SMS notifications by default for events synced from Outlook. So, we will have to make Google do it! (through scripting). Open a new spreadsheet in Google Docs ( google.com/docs). In the spreadsheet's menu, go to tools=>script_editor . Paste the code:
 -------------------------------------------------

function SmsReminders() {

var today = new Date();
var Calendar = CalendarApp.getDefaultCalendar();
var events = Calendar.getEventsForDay(today);

for (var i = 0; i {
   events[i].addSmsReminder(30);
}

}

--------------------------------------------------
Now save the script.
Click "Triggers"  on the same window > Current Script trigger's > Add  a trigger. Set it "Time-driven | Hours timer | Every 1 Hour > Save.
Note: This will run the script every 1 hour and the script would add SMS reminder to all the events it sees in the Google calendar, to be sent 30 mins before the event.
Save the Script and now the script editor window can be closed.
Save the spreadsheet.

We are done! To summarise, we synced our outlook events to google calendar and since google doesn't send SMS reminder for synced events by default, we enabled it though a script. All actions must be performed through the same google account!

Please leave a comment in case of any difficulty faced.

2 comments:

  1. Now this is awesome shitt!!! Would love to try but as of now can't sync my Outlook calender with G-Calender. Will try this definitely :)
    P.S. Never knew you could use scripting in G Calenders.

    ReplyDelete
  2. btw, for loop closed nahi hai :P and what if we activate daily notification on mobile? We wont need the script ryt until and unless you need your notification the hour before your meeting.

    ReplyDelete