Display available session on calendar

[therron36]

Hi once more..

I'm trying to display session times that are available for each day on a calendar in month view. I have an "events" table with the field "available sessions" which is displayed in each day of the calendars month view.

"available sessions" is a calc field with the following.

Case ( IsEmpty ( Title ) and Time = Time ( 9 ; 0 ; 0 );"9 am" )

;IsEmpty ( Title ) and Time = Time ( 10 ; 0 ; 0 );"¶""10 am"

;IsEmpty ( Title ) and Time = Time ( 11 ; 0 ; 0 );"¶""11 am"

;IsEmpty ( Title ) and Time = Time ( 13 ; 0 ; 0 );"¶""1 pm"

;IsEmpty ( Title ) and Time = Time ( 14 ; 0 ; 0 );"¶""2 pm"

;IsEmpty ( Title ) and Time = Time ( 15 ; 0 ; 0 );"¶""3 pm")

cal is unstored & result is text.

so if the 9am & 10am sessions are available for a particular day 9am & 10am will be displayed for that day on the calendar .

Can't get this to work.

Any advice would be greatly appreciated.

[IdealData]

The Case() function stops evaluating after the first successful condition is met, so your calc can only ever show one available time slot.

[therron36]

Hi

I must be missing something. Why does this work:

"Sessions Available" in the events table:

Case ( IsEmpty ( Title ) and Time = Time ( 9 ; 0 ; 0 );1

;IsEmpty ( Title ) and Time = Time ( 10 ; 0 ; 0 );1

;IsEmpty ( Title ) and Time = Time ( 11 ; 0 ; 0 );1

;IsEmpty ( Title ) and Time = Time ( 13 ; 0 ; 0 );1

;IsEmpty ( Title ) and Time = Time ( 14 ; 0 ; 0 );1

;IsEmpty ( Title ) and Time = Time ( 15 ; 0 ; 0 );1)

"EventsMonth" in the calendar:

Sum ( Events_Month::Sessions Available )

The EventsMonth field displays the number of sessions available for those times on that day without a problem.

[therron36]

O.K.

Increase the number of repetitions for the cal field & all works well.

Thanks IdealData