Sync Multiple Google Calendars to your IOS 7 Device.

I have had a lot of users come to me because the IOS 7 update caused issues with not all of their Google Calendars not showing up on their mobile devices. If for some reason no calendars or contacts are showing then you should delete your account and re-add.

To get started on your mobile device head to https://www.google.com/calendar/syncselect 

You will have a list of your available calendars. Simply select the calendars that you want on your mobile device.

Close the calendar app.

Re-open the calendar and refresh the app by dragging down on the screen. It will take a few minutes for all of the calendars to show up.

 

As always let me know if you need anything!

@tjhouston

Recovering the Acer C710

Recently we ordered roughly 75 C710’s for our high school. All but one of the devices came pre-enrolled and every time we tried to enroll it we got an error that it could not be completed. We tried power washing the Chromebook and still had no luck. The only option we had was to restore the device and re-install the Chrome OS. Here is how we did it!

(more…)

Google Scripting + QR Codes = Awesomeness

Todays post came from a comment from a reader who asked about inserting QR codes into Google Spreadsheets. There are a few things that this can be used for such as ticketing for an event, etc. Its not exactly what the reader asked for but its a step in the right direction. Screen Shot 2013-06-24 at 3.12.35 PM

Below you will see the end result of what we are doing:

Screen Shot 2013-06-24 at 3.13.23 PM

So after some time playing with the URL and encoding (reference here: http://www.w3schools.com/tags/ref_urlencode.asp) I found that I could bring in values from different columns and insert them into a QR code.

 

All we are doing in our cell is using the =image formula and making a call to the chart API (https://developers.google.com/chart/ )

 

Here is an example of what we are doing:

Api Call:

=image(“http://chart.apis.google.com/chart?chs=150×150&cht=qr&chl=Name%3A%20″&A2&”%20″&B2&”%20DOB%3A%20″&C2&”%20Notes%3A%20″&D2&””)

 

You can find the example spreadsheet here: https://docs.google.com/spreadsheet/ccc?key=0At-tnrDq1KRmdGdISXZrZ0dHQW9fMlRQNmxaNXdmMVE&usp=sharing