Examples of CDML for a Simple Calendar

[army]

Has anyone seen any example html files for a simple calendar ? I've seen the example calendars in the sample files, but I was hoping someone might have seen some example's with the cdml to use on the web.

[Jeff Spall]

Hi, I generate monthly and weekly calendars for our online meeting room and employee holiday booking system.

Here's some screen shots of what I mean:

http://www.william-reed.net/examples/year.gif

- shows the whole year down the page. Clicking the arrows take you forward or back a year, clicking the week or month link you to that week or month

http://www.william-reed.net/examples/week.gif

- the detail page from the calendar above which draws in the bookings. clicking the arrows takes you forward or back a week

http://www.william-reed.net/examples/day.gif

- draws bookings by the hour for a single day

because all of these are cdml based they can be used for making/showing date/time events. If you just want a display calendar, JavaScript is much simpler:

http://www.william-reed.net/examples/javacalendar.gif

I use this popup one to paste a date into a form box

If any of these look useful, I can help with code examples, but it's not simple!

regards, jeff

[army]

Thanks Jeff for showing me your examples, they look totaly awesome, but way too advanced for me (a mostly right brained FileMaker novice). I have another question for you. I have three database's (different kinds of things that would go on a calendar) with completely different fields, they only have one field in common (month of the things). How would I go about creating a search page that could pull up a results page from the three different databases. I am thinking I have to create a fourth database with the month field which is related to the other databases. Could you talk me though how you would do it? Please speak slowly.

[Jeff Spall]

Do you want to display stuff from the databases into a calendar? Building a cdml calendar isn't too hard until you need to set up things like date-to-range relationships.

If you need to bring in info from three separate sources, I can think of two ways:

The new database with a month relationship to the other ones is a good way to go. Create portals for each DB on your new one and use that directly, using related fields in your web pages. Nice and easy without any cdml tricks.

The other way would be to use inline actions. Call your page from the first database and then pass the search criteria into the inline to search each of the other databases in turn.

To make a calendar work, I have a calendar database which has relationships to the ones that hold the data. The page display code looks like this:

for the year calendar page:

http://www.william-reed.net/examples/example2.htm

and for showing a month with stuff in the days (here only coloured bars)

http://www.william-reed.net/examples/example.htm

(get the source - they look crazy viewed as html

I'll try to post a working example if you'll be patient for a while ('cos I can't remember exactly how all that stuff works) and it does start getting a bit complcated to describe. Would you be thinking of displaying, say a month with stuff in the days like an event calendar??

regards, jeff

[army]

Hi Jeff,

I haven't totally decided how to do it yet, but I do want to display the stuff from the databases into a event calendar. I think, to keep it simple, perhaps I could just have it pull up a list of stuff by month, like:

October

Event 1

Event 2

event 3

November

Event 1

Event 2

event 3

And then you could click on the event to get a detail page.

I think I will try to set up the new database with a month relationship to the other ones and create portals for each DB on the new one and use that directly, using related fields in your web pages, as you suggested. That way sounds easier to me. I really appreciate your help. I need all of it I can get!

[Anatoli]

If you will set simple "calendar" database, with all days then you can easily have portal with relation set by date and in portal you will have the events.

That is working OK through CDML.

Or the same with monthly relation.

[Jeff Spall]

Hi,

Quote:

keep it simple, perhaps I could just have it pull up a list of stuff by month, like:

October

Event 1

...

November

Event 1

...

And then you could click on the event to get a detail page.

I think I may I have something very like this:

http://www.william-reed.net:591/calendarf/FMPro?-db=days&-lay=layout1&-format=currentcalendar.htm&-errror=search_error.htm&-sortfield=calendardate&-sortorder=ascending&-op=eq&weekcounter=yes&-Find

........sorry about the url.......... some bits like the search and some links might not work on the public internet (I hope not!!) but you can get the idea. An inline also displays related pictures and captions down the right hand side but our lazy administrators havn't added any this month!

If this is the kind of thing you want, I can zip up the database and some pages for you. It would be easy to display a number of months rather than just the one and maybe display it as a calendar format.

regrads, jeff

[army]

Hi Jeff,

Yes, that is what I had in mind. If you could zip up some of you files for me to look at that would be so cool!

Extremely Grateful,

Army

[Jeff Spall]

Hi, I've uploaded two versions of the same files:

http://www.william-reed.net/examples/event_calendar.zip

and

http://www.william-reed.net/examples/event_calendar.sit

IMPORTANT: i added a '.fp5' suffix to the two database names in case they didn't survive 'zipping without it. You'll need to remove that to get it to work properly.

Now I look at this (and it's a couple of years since I did it) I realise it's really very simple, exactly as Anatoli predicted, and doesn't involve a real calendar at all. Not surprising, as I probably got the idea from him anyway!

If you just dump the "calenadarf" folder into your FMPro web folder and call it from the url in the 'read me' file.

Pleaase get back to me if it doesn't work or if you need more of an explaination

regards, jeff

[army]

Hi,

I downloaded them and they do work. It looks like something even I can handle! If you ever get to Houston Texas, let me know and and I'll buy you dinner.

[Jeff Spall]

Hi, I'll remember that! Long way from Surrey, though

regards, jeff

[Leb i Sol]

for the Calendar HTML entry side here is a free JS file......perhaps of no use to you....perhaps it is.....

in any case, file is attached!

All the best

JS_calendar.zip