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.

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

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.

O.K.

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

Thanks IdealData