Scheduling

[Gunnerstudios]

Hey

First I need to say thanks for Søren Dyhr to create this calendar function back in 2006.. =)

Called CalcVsGenSlots

CalcVsGenSlots

to quickly fill you guys in here is a summary what Søren Did. with my modifications

Here is following tables and relationships

Relationship

Events::Start_time = schedule::cSchTime

Events::Date = schedule::cSchDate

Table 1 (schedule)

Fields

cSchID, | auto enter serial

cSchTime | Mod ( SlotID - 1 ; 48 ) * 30 * 60

cSchDate | Let ( [

sunday =Contacts::gDate - DayOfWeek ( Contacts::gDate ) + 1

] ;

sunday + Div ( SlotID - 1 ; 48 )

)

Table 2 (Events)

Field

EventID auto enter serial

EventType (text)

Start_time

End_time

Date

Table 3 (contacts)

Field

ContactID auto enter serial

cWeekDatesR

gDate

Name

Adresses

Etc...

So far so good.

i have modified the portals so they only show records from 08:00 - 18:00 each day. works fine.

When I make an Event (Date 17.07.09) (Start_Time 08:00) (End_Time 10.00) (EventType Lunch )

It shows perfectly as and planed, it is Lunch as 08:00 but it show is end at 08:30. How can I make so EventType show until End_Time (10:00)

I tried to create a new field in Schedule called cSchEnd_time, an create a relationship "Event::End_time = Schedule::cSchEnd_Time. The portales doens show any data.

@@@@

I know newbe misstake.... i needed to < Time Start > Time End

Please help

So my second question, do you understand what i mean?

Kind Regard

G

Edited July 17, 2009 by Guest

[Gunnerstudios]

I sloved it.. hehe. it was a newbie misstake.

see above for the answer.

Thanks again to Soren for making the template for me!

Worth while to look at if you are after a scheduling or a roaster

[Søren Dyhr]

While I really can take the responsibility for quite a handful of templates here, are you mistaken by this particular one's origin. It stems indeed from something Comment and I debated eagerly back then, to make enough slot records to handle an forseable future or just design the solution to cater the visible slots in the most crowded layout, with a transitive key (a calc) instead of the hardwired from the prefabbed records. It's Comment's template!

The difference seems near seemless in a single user version, but the negotiation in the round trips in a networked solution, and especially an IWP'ed - favours the hardwired.

Hows about signing into a triple 8 IWP trial of one month and try the two approaches against each other?

http://www.triple8.net/hosting_filemaker.htm

--sd

[comment]

Please do not link directly to files from other threads. As Søren's response makes clear, these files are demos posted in the course of a discussion, and they should be studied in that context.