First a word of thanks for the calendar - I'm very much a beginner but its made my application look amazing!

I'm haviung trouble adding an additional source within the eventstable.
I have added a second set of datestart, timestart and time end fields to my eventsdetails table. However, when I come to mapping the fields I dont know what to enter in the section that says.....

"The start date and time for your event converted to a timestamp: must use the definition from z_sc_TimestampStartCalc found in the sample events table."

These are already "used" by my first set of dates and times. What do I do?

Hi Roy,

Thanks for the kind words. The additional sources are really designed to be used on separate tables. If you're trying to "slice-up" the single event table, then using filtering will work much better. The default filters we give you are pretty extensive, but you could add additional filter fields, including one called "source" and then just filter on that field. That would be a lot easier, and will perform faster, than setting up another source itself.

http://www.seedcode.com/pmwiki/pmwiki.p ... ar.Filters

Let me know if that helps, or if you have any other questions,
Jason

Hi Jason,

I can understand how filtering would work if I had one date/time that I wanted in the diary depending on the filter. However I cannot see how I can use this to see the same event more than once in the diary.

Eg I have a "booking date/time" a "viewing date/time" and a "follow up date/time" all in the same record. How can I get the calendar to show all three of these in the diary at the same time?
--------------
On a separate point, I am getting the error
"We cant go to the correct layout. Either no source number parameter was passed into the script or there is no source X layout where x is the source number. "

There is a "Source No 4" layout. What am I doing wrong?

Thanks

Hi Roy,

I get it now. Hmmm...I think a better set up would be making "booking", "viewing" and "follow-up" individual events and tie them together somehow. Either with a parent record (project?) or tie them together as we would with a repeating event.

As I think about it, your approach might work, but you would breaking new ground =)

The error your seeing is coming from the subscript:

Load Source Settings by Number ( SourceNo ) { Action }

If you have FileMaker Advanced, then stepping through with the debugger would be the best approach. My suspicion is that the parameters aren't being passed correctly and the variable $sc_SourrceNo is not getting populated correctly. We just calculate the layout name from the parameter and then try to go to the layout by name. If we can't find the layout, then we throw that error.



Let me know if that helps,

Thanks Roy!

Hi Jason

I deleted the problem source and redid it from scratch and it worked OK - thanks for the pointer.

I want to be sure I understand the concept completely....

In your docs it says " You can even have multiple sources from within the same table: if, for instance, you had a job due date in your jobs table and a followup date in your jobs table, you'd create those as two separate sources. "

I'm guessing that is not possible - you cant have two sources from one table, each source must have its own table. In this case you'd have to create a table called followup, link it to the jobs table and have the calendar list entries from it.

HOWEVER, by having the linked followup fields listed on the jobs layout, and making the jobs layout the display layout for both sources, you can achieve the same result (albeit maybe a little slower than if there was only one file.) So thats the perfect workaround.

Have I got this all right?

Good Morning Roy,

Glad that worked on Source No 4!

Technically, you can set up two sources based on the same table. I typically steer people away from multiple FileMaker sources in general if they can achieve it a different way, as it can be somewhat complicated and there is a performance hit (you're doing separate searches and variable loads on the same table.) There can also be some additional customization required when clicking on the calendar with overlapping events from different sources, and applying filters.

I think having multiple / related events in the same table and source would probably work the best, but setting up multiple sources from the same table, with different date mapping, would be my second choice. It sounds like you've got a pretty good handle on it, so I would proceed. I'd also love to see how it comes out, and maybe my biases can be overcome

hth,
Jason

Cheers for the help - be glad to let you see it when its done

Thanks

Roy

Thanks for sharing Roy. It looks great.