So.....

Mods, Tips, Tricks, and Support for Zulu
Posts: 32
Joined: Sun Dec 06, 2009 9:49 am
PostPosted: Thu Aug 26, 2010 11:10 am
I have one table that has the activities for all our users of the database. Can I use zulu to make an iCal calendar for each user and have it show just their activities that are marked as pending?
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Thu Aug 26, 2010 2:15 pm
Yes. You can publish that one table as more than one calendar. Zulu lets you filter by a single field in the table: so you can filter by the User field to create one calendar per user.

This is shown in our overview movie, where we filter by status...

http://www.seedcode.com/movies/zulu/intro.html

...and described here:

http://www.seedcode.com/pmwiki/pmwiki.p ... eCalendars

To show only "pending" events per user you have a couple options:

- you could create a new auto enter calc that contains the user name only if the event is pending and filter on that,

-or you could use our "deleted" field (this is one of a few new fields you'll add to your table): any events with a 1 in there don't show up on the calendar, so you could script a 1 into that field when events are no longer pending. Do it with scripts though, don't make "deleted" an actual calc field.

Hope that helps,

John
John Sindelar
SeedCode
Posts: 32
Joined: Sun Dec 06, 2009 9:49 am
PostPosted: Fri Aug 27, 2010 4:43 am
or I could make a calc field for filtering?

c_zulu filter = appt::user_id & appt::status

and just filter for something like "user001pending"

sounds like less work :)
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Fri Aug 27, 2010 5:49 am
Except that you can't use calcs for these zulu attributes...

When you make a new event in this calendar in iCal, Zulu needs to be able to write the filter criteria.

...so do the same thing but use an auto enter calc. The other thing to consider is that if your filter is something discrete, like user or status, then moving an event from one calendar to another in iCal will change the user or status of the event. Maybe that's not something you need to do, but you kind of lose that when you make the filter value an auto enter calc.
John Sindelar
SeedCode
Posts: 32
Joined: Sun Dec 06, 2009 9:49 am
PostPosted: Fri Aug 27, 2010 6:25 am
what causes zulu to change the contents of the filter field? and what does it change it to?
Posts: 32
Joined: Sun Dec 06, 2009 9:49 am
PostPosted: Fri Aug 27, 2010 6:27 am
on another note you really should have full video tutorials for your solutions. you do them so well :)
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Fri Aug 27, 2010 7:04 am
Thanks!

When you create a filtered calendar, you specify the field to use as a filter, and the filter criteria. So the field may be Status and the criteria, "Done".

If you switch an event from another filtered calendar based on the same table (say the "In Process" calendar) to the "Done' calendar, Zulu sets the filter field to the new criteria, setting Status to "Done" in this example.

Unfortunately you can't change an events calendar on the iPhone or iPad calendars; that's a limitation of iOS.
John Sindelar
SeedCode

Return to Zulu: iCal Server for FileMaker

Who is online

Users browsing this forum: No registered users and 2 guests

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