A more elegant auto-calc?

[merkaba22]

I have an auto-calc field with:

Case ( playlist_show = "BFC"; "4p";

playlist_show = "HWD"; "4.5p";

playlist_show = "HHS"; "5p";

playlist_show = "ROS"; "6p";

playlist_show = "BLA"; "7p";

playlist_show = "ROS"; "7.5p";

playlist_show = "ROS"; "8";

playlist_show = "HWD"; "8.5p";

playlist_show = "PTI"; "9p";

playlist_show = "ROS"; "9.5p";

playlist_show = "WLD"; "10p";

playlist_show = "BDB"; "10p";

playlist_show = "ROS"; "10.5p";

playlist_show = "ROS"; "11p";

playlist_show = "JCR"; "11.5p"; )

In the case of ROS, the show can be at more than one time; in the calc I have provided above, those possibilities are not available -- further, since the result is a calc, no value list can be added to select the various times that the show can air.

Is there a work around besides using something like:

"ROS - 6"; "6p";

"ROS - 7.5": "7.5";

etc.

to provide a more elegant solution?

[Raybaudi]

Hi

if we can't change the word ROS to something like ROS1, ROS2, ROS3 etc.,we have to make 2 conditions...

For example:

case(

playlist_show = "ROS" and Get ( CurrentTime )= 18:00; "6p";

playlist_show = "ROS" and Get ( CurrentTime )= 19:30; "7.5p"

)

or something about... but we have to know more about your DB !

[merkaba22]

Hey raybaudi!

Yea, I am trying to avoid ROS1, etc. -- it can be done and I understand how to do, but it seems clunky for this day and age.

The other is not a bad idea except these show times are preset possibilities and don't run off CurrentTime.

There is a field called "playlist_show" that contains a VL for the shows as listed above. The auto-calc fills in "playlist_airtime" accordingly.

However, the ROS show has 6 possibilities and FM only returns the first choice via the calc I explore as posted above -- I am looking for a way to offer that additional choice to the user .....

I suppose I could have "playlist_airtime" be a lookup and then offer a value list fo the case of ROS ...

Thought there could be a way to dig in deeper and get a better calc:)

[Raybaudi]

But the VL is a custom type ?

Because perhaps we can check the row, not the name of the value !

[merkaba22]

Daniele!

I am sorry that I do not understand .... the VL is a field from another table: BFC, HWD, etc.

In th einterim I have made "playlist_airtime" be a lookup and then offer the various values in a VL fro the case of ROS ...

Not elegant at all:(

[Raybaudi]

the VL is a field from another table: BFC, HWD, etc.

But, if the VL is coming from a field of another table, how can you show so many ROS ?

(it is possible only if you sort by another field like an ID field !)

How many times ROS is entered in the other table ?

[merkaba22]

I don't show so many ROS -- in my orginal calc idea there was only one; therefore, the VL from another table just shows each of one show as listed above. ROS is only once in the other table.

I was just wondering if there would be calc possibility that shows up in the playlist_airtime for the various time slots that could be assigned to ROS .....

Edited December 8, 2005 by Guest

[SurferNate]

It sounds simple enough to me to just add a TimeSlot field to your Programs table and add records for ROS for each additional timeslot. Then you can have a value list of concatenated values which will show each program and timeslot for selection. ROS will still only show up once in your original value list but you can have a second value list that includes the timeslots too.