I know there has been many post on something similiar to this, but I haven't found anything current. Here is what I'm dealing with. I have a layout with a month calendar in it. I've already written scripts to show the appropriate day numbers according to the month were veiwing. Here is the problem, I have another table that holds all the call logs. I want to show in the calendar view the total number (the sum) of all the incoming calls on that peticular day in the calendar. For example, the calendar shows all the days of the month of March. In the March 2nd box I want to see an number that represents the total number of incoming calls (from the call logs) on March 2nd. My question is, do I have to create a table for each and every square (42=7days * 6 weeks) that a day number can go into? I know I can do this with a script. The problem is that a script isn't live. Any thoughts?

In general, calendaring solutions are often done with calculations. If you're doing that and have the layout setup correctly for the display, the cells of the calendar should be relatable to a date. Unfortunately, if you don't have the calendar view setup with calcs and instead are using scripts to create a static array, you'll likely have a bit more trouble with this kind of solution.

I originally started with a calc for each box. I switched gears when the calculations for each box started slowing down the database. I figured since scripts only happen when triggered it wouldn't slow the system down. The other reason I switched gears is with a calc solution it seemed I would need a TO for each box in the month(42).

You might want to take a look at the calender by SeedCode.com (should be a link at top of all FMforums web pages) They have a nice calender and if nothing else, it might be usefull to look at how they do this. (they should have free unlocked versions you can look at.)

Here's one from JMO that's really about good enough for most solutions:

http://www.databasepros.com/calendar.html

It's open so you can look at how it ticks.

Unfortunately they only provide a complete solution. I need a version that I can open up and see how its put together. Were on a small budget so buying something to suplement what I'm working on is not an option.

SeedCode.com verison is nice but maybe a little overkill for what I need.

Then search the Sample Files here for Calendar.

Lee

You do not need 42 TO's for this solution:

http://fmforums.com/forum/showtopic.php?tid/176396/post/204083/hl//fromsearch/1/

...5-6 is more likely, and is BTW the solution behind Mike Gamble's advice! Just for the hell of it, try to compare the rendering of your suggested 42 and then what's done in that thread!

--sd

Callendar is a small town in the center of Scotland, where it rains every quater of the hour ... so the view must be quite blurred!

Edited September 18, 200718 yr by Guest

Hey all, thanks a ton. The advice and solutions you provided has saved me a ton of work. Mike Gamble, you were right. The best calendar sollution does use calculations. I'm amazed at how complicated I was making it. Thanks again.

Ok, to through a wrench into the works. How would I go about it if I needed a sum value rather than appointments in each day of the calendar. Each record I'm pulling the sums from only has two values(InComing and OutGoing).

I have in my version of the approach:

http://fmforums.com/forum/attachment.php?attid/7281/

...a special home-knitted aggregate function called "SinceWeAreInAPortal" to overcome the problem with a portal inside a portal, which easily could be exchanged with another much simpler - say Sum( which in your case perhaps should be two of them, one for InComming and one for OutGoing. My table event could obviously be eased from a lot of it's fields, since the issue it solves is recurring events booking.

Now you could perhaps implement some of the shenanigans I use in this thread:

http://fmforums.com/forum/showpost.php?post/266573/

...because each record shouldn't have two fields where one is empty and the other holds a value, the proper structure is avoid null values, although Filemaker's aggregate functions deals with such in a spreadsheet'ish metaphor. Other tools gives wrong results with attempts to make calculation with NULL...

--sd