Difference between revisions of "Google Calendar Tricks"

From HeadBackup
Jump to navigationJump to search
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
= Word Wrap =
 
== Initial Install ==
 
== Initial Install ==
 
# Install the [https://addons.mozilla.org/en-US/firefox/addon/748?id=748 Greasemonkey] plugin for Firefox
 
# Install the [https://addons.mozilla.org/en-US/firefox/addon/748?id=748 Greasemonkey] plugin for Firefox
# Install the [http://userscripts.org/scripts/show/5850 Google Calendar Textwrap Events]
+
# Install the [http://userscripts.org/scripts/show/5850 Google Calendar Textwrap Events] script
  
 
== To enable wrapping on embedded calendars ==
 
== To enable wrapping on embedded calendars ==
# Once the above are installed, right click on the monkey icon at the bottom of the browser and then click on user scripts
+
# Once the above are installed, right click on the monkey icon at the bottom of the browser and then click on manage user scripts
 
# Under the Google Calendar Texwrap Events script add another URL as follows: <pre>http*://www.google.com/calendar/embed*</pre>
 
# Under the Google Calendar Texwrap Events script add another URL as follows: <pre>http*://www.google.com/calendar/embed*</pre>
 +
 +
== Green key image ==
 +
[[Image:Green_birthdays_%26_anniversaries.jpg]]
 +
 +
= Exporting Events to a Spreadsheet =
 +
 +
== Issue ==
 +
Agenda view comes close to doing what I want, but has the following limitations:
 +
# Can't display events from an entire year in a single list
 +
# Can't easily export/print events without including the event creator and calendar names (each event takes up several lines instead of just one)
 +
 +
== Fix ==
 +
To get around these I found the following helpful third party site which will export your events to a spreadsheet (Excel or Google Spreadsheet):
 +
* http://www.gtimereport.com/Home.aspx/Export
 +
** Uncheck the box to filter whole day events
 +
** Check the box to show end time column
 +
 +
= Syncing Other Calendars to iPhone =
 +
== Issue ==
 +
Some calendars shared from other people don't show up on iPhone calendar app.
 +
 +
== Solution ==
 +
Enable syncing for calendars on this page: https://calendar.google.com/calendar/syncselect
 +
 +
Source: https://www.online-tech-tips.com/computer-tips/sync-all-google-calendars-with-iphone/

Latest revision as of 04:31, 25 May 2022

Word Wrap

Initial Install

  1. Install the Greasemonkey plugin for Firefox
  2. Install the Google Calendar Textwrap Events script

To enable wrapping on embedded calendars

  1. Once the above are installed, right click on the monkey icon at the bottom of the browser and then click on manage user scripts
  2. Under the Google Calendar Texwrap Events script add another URL as follows:
    http*://www.google.com/calendar/embed*

Green key image

Green birthdays & anniversaries.jpg

Exporting Events to a Spreadsheet

Issue

Agenda view comes close to doing what I want, but has the following limitations:

  1. Can't display events from an entire year in a single list
  2. Can't easily export/print events without including the event creator and calendar names (each event takes up several lines instead of just one)

Fix

To get around these I found the following helpful third party site which will export your events to a spreadsheet (Excel or Google Spreadsheet):

Syncing Other Calendars to iPhone

Issue

Some calendars shared from other people don't show up on iPhone calendar app.

Solution

Enable syncing for calendars on this page: https://calendar.google.com/calendar/syncselect

Source: https://www.online-tech-tips.com/computer-tips/sync-all-google-calendars-with-iphone/