Hi John:

We've been using the iCal Subscription Kit to access our remotely hosted FM solution. Following your instructions, I've succeeded in "filtering" the data so that only my appointments (i.e. ApptUser_kf=JR) are accessed. Here's my URL:

Code: Select all

http://obotc.pointinspace.com/fmi/xsl/[my account folder]/vcal/ccical.xsl?-db=[my fm solution]&-lay=vcal&ApptUser_kf=JR&-find&-grammar=fmresultset

Now, I'd like to filter this further, so that only my appointments from 2008 show up in our calendar. I've tried editing the URL, adding something like

Code: Select all

&ApptDateStart=2008

without success. Can this be done?

Yours,
Jim Recht

To do that you'd need a new calc field in the calendar that returned the year of the start date: something like...

ApptDateYear defined as Year ( ApptDateStart )

Then your URL would include &ApptDateYeart=2008

I tried using

Code: Select all

&DateStart>12/31/07

but that didn't seem to work. It should be possible to use the DateStart field in a calculation like this though, shouldn't it?

Jim