Posts

Showing posts with the label Calendar

Subscribe Google Apps users to calendars using GAM and python

If you want to subscribe a Google App user to calendar, you can use GAM and python. This following script my get you started: Note: You have to have GAM up and running before running this script.

Displaying Bell Schedule info on admin and teachers pages header of PowerSchool

It's quite useful displaying the bell schedule info of the day on the admin and teachers pages's header in PowerSchool. Here is how to do it: 1. Go to PS Administrator >> Custom Pages 2. Add this following code to wildcards/admin_header_css.txt and wildcards/teacher_header_css.txt <span id="ssis-date" style="padding-right:20px;"> ~[tlist_sql; select b.name as name, listagg(p.ABBREVIATION || ',') WITHIN GROUP ( ORDER BY bi.START_TIME) AS periods     from ps.calendar_day c inner join ps.BELL_SCHEDULE b on c.BELL_SCHEDULE_ID = b.ID         inner join ps.BELL_SCHEDULE_ITEMS bi on bi.BELL_SCHEDULE_ID = b.ID         inner join ps.PERIOD p on p.ID = bi.PERIOD_ID     where TO_CHAR(c.DATE_VALUE, 'DD-MM-YYYY') = TO_CHAR(CURRENT_DATE, 'DD-MM-YYYY')         and c.SCHOOLID = ~(curschoolid)     group by b.name; ]     <span style="color:#195f7d">~(name):</span> ~(p...

Link to add an event to your google calendar

This is a common functionality you want to add to your event website that will help your users add the event schedule to their Google calendar. Simply using this following html syntax: <a href="http://www.google.com/calendar/event? action=TEMPLATE &text=[event-title] &dates=[start-custom format='Ymd\\THi00\\Z']/[end-custom format='Ymd\\THi00\\Z'] &details=[description] &location=[location] &trp=false &sprop= &sprop=name: &ctz=[timezone]" target="_blank" rel="nofollow">Add to my calendar</a> For Example: <a href="https://www.google.com/calendar/render?action=TEMPLATE&text=Vietnam+Tech+Conference+2017&dates=20170311/20170313&details=For+details,+link+here%3a+http://vietnamtechconference.org&location=Saigon+South+International+School,+Tân+Phong,+Quận+7,+Ho+Chi+Minh+City,+Vietnam&output=xml&ctz=Asia/Ho_Chi_Minh" target="_blank" rel="nofollow...

Google Apps Script - Send SMS when receiving an email in GMail

Image
So, you don't have Internet access but still want to be notified whenever someone special email you (GMail)? Here you go: Google Apps Script FTW. 1. In GMail, create a label name "Send SMS", then create a filter to apply that label to whichever messages you want. For example, every message coming from the email address my-love-one@gmail.com will be applied the "Send SMS" label. 2. Go to Google Apps Script , create a blank project, paste this script into the script editor: Every time the Gms_send_sms runs, it will get all email messages which have "Send SMS" label. Create an event in the Google Calendar for each message. Create an SMS notification for each of those events. Remove the label of those messages 3. In the script editor, select Resources menu >> Current project's triggers >> create a trigger to run the Gms_send_sms function every 5 minutes. You will need to grant permissions for the script to access your gmail...