SeedCode Support Forum

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?

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

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

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.

what causes zulu to change the contents of the filter field? and what does it change it to?

on another note you really should have full video tutorials for your solutions. you do them so well

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.