Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
Is there a way to automatically increment a number inside of a recurring event in Google Calendar?
Basically, what I'd like to do is add an event that tells me how old my daughter is, by week and by month, until she is two.
My memory is terrible and it sucks to stop and count the weeks every time I need to know this.
I was looking to do something similar for a 90-day workout routine. I ended up writing a simple bash script, using GoogleCL, that added an event for each of the next 90 days with the week and day number of the course in the title of the event.
Something similar could easily be done to count the age of your daughter. A search for GoogleCL should bring up needed info.
I guess the drawback is that the events are not "linked" like a recurring event is if you want to make a change later.
@digitxp Maybe this is an even nerdier solution?
I wanted to do the same, and this site generates an arbitrary weekly event.
Arbitrary week number generator for ical compatible calendars
If you require week numbers for you calendar but your week one does not on the first week of the year you have some problems. Google Calendar and several other gizmos offer week numbers but they all start on the first week in January. This php script can help.
Instructions: enter a name for your calendar, choose the date to match the first day of the first week for your week one and press the do it button. The script will take you to a directory where your week number calendar is stored. Save this to your computer and then import it into your calendar. In google calendars I recommend creating a new calendar called week numbers and then importing the events to this (it makes it easier to delete the dates if you go wrong and makes it easy to change colours etc etc). the import function is via the "gear" that appears top right: calendar settings:calendars:import calendar. Remeber to import to "week numbers" for ease of use.
Beware, create an extra calendar to import the ical to, because it might be difficult to clean it if you make some mistake.
It will take a little bit of work, but you could create a CSV in Google Spreadsheets as outlined per "Advanced: Create or edit CSV or iCal files before importing".
Google Spreadsheet would allow you to AutoFill (and increment) the week numbers.
This was my question but it appears to have been moved incorrectly from superuser.com (my login always carried over from stack to superuser but not superuser to web apps).
Anyway, I want to do this so it'll sync with my Android phone :)
