iCal Subscription Kit: can it filter by date?

Support for our integrated Contact Manager, Calendar, and Project Tracker.
Posts: 116
Joined: Mon Sep 04, 2006 1:19 pm
PostPosted: Tue Mar 11, 2008 5:29 am
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
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Tue Mar 11, 2008 11:47 am
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
John Sindelar
SeedCode
Posts: 116
Joined: Mon Sep 04, 2006 1:19 pm
PostPosted: Tue Mar 11, 2008 3:18 pm
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

Return to SeedCode Calendar

Who is online

Users browsing this forum: Google [Bot] and 2 guests

cron
(855) SEEDCODE
[email protected]
Follow us: