Calendar report layout

[trevors]

This is my 2nd problem with current project. This one I don't really have any idea. I am designing a bookings database for an Entertainment company (electric bull, castles etc).

I have the following tables.

- Clients

- Bookings

- Products

- Delivery Details

All seems to be working OK, but I would like a report in a calendar layout for each month. can this be done, through Filemaker, or a third party plug-in etc?

Something like this - standard online events calendar layout. http://www.calendarscript.com/demo/calendar.pl

Many thanks

Trevors

[David McQueen]

Yes you can.

There is a plug in. I forget which one now. Perhaps someone will chime in.

You can roll your own. If you go to my site and download Little Helper, you can see one in action or view some screen shots. There are others, perhaps even free demo's. Again, some one can chime in here.

There are some magic numbers with calendars

42 - Number of days you have to show, the number of self relations you would want.

7 - the first cell you know will have a date in it every month

Basically all it is is a screen of 42 portals capturing properly keyed events.

HTH

Dave McQueen

[Hoggy]

Here's a screenshot of a solution I came up with a while ago for a similar problem. (In this case, equipment hire)

Each record has a calculated field for each date on the planner. They're only calculated when needed. A script sets the start date of the planner and everything else is calculated from that.

The blobs you see are dingbat fonts, text results for a date calculation.

The leftmost date calculation goes something like:

if planner start date = date out

display one type of blob

if planner start date >date out < date back

display differeent type of blob

And so on.

The next calculation goes

if (planner start date+1) = date out

etc.

It was annoying and time consuming to code, but I'm quite happy with the result.

The date headings are also calculated, again relative to the planner start date.