Database calendar

[cruijff]

Hi guys,

I'm designing a database for a small company and I was thinking about implementing a calendar which could sum up all the things that have to be done daily.

As an example I have a Payment table linked on a 1to1 relationship to a date table, i.e. paymentID = paymentID(in dates) AND dateID = dateID(in payments). Each payment has a date (and some calculation is going to be run on that date). I'd like to display those dates in some sort of calendar so that the user could see each day what payments (or other stuff) he has to do.

I found some solutions online for filemaker calendars and I wanted your advice about that.

Shall I create a calendar from scratch using maybe list view on Date table layout?

What and how do you use a calendar for in your database?

(Don't know if I'm posting in the right section)

Thanks!

[Lee Smith]

Hello cruiff, and welcome to the forum

Every developer should try to do this at least once. It's a good exercise that will test your FileMaker skills.

Have you looked at the files that came with your FileMaker application? A couple of those may work out to be what you need. One that comes to mind is called Events Manager

Also, do a search using Google for “build a calendar in FileMaker” and you will get several hits of sites.

Lee

[Vaughan]

Take a look at SeedCode's free calendar.

[cruijff]

I will try to set up my own calendar and I honestly forgot there's an event manager on fm templates, I'll take a look.

Thanks Lee, I suppose it'll be a challenging issue being able to create my own calendar, I was just wondering if some of you fm pros had any precious advice/tip/secret ( ) to give about managing a calendar. Do you think it's correct the way I linked on a 1to1 relationship Dates with "event" (Payment in this case)?

@Vaughan: that was the solution I was referring to in my post, do you use it? What's your overall experience? Do you feel like something is missing or improvable? Thanks!