Jump to content

A more elegant auto-calc?


This topic is 5756 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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 !

Link to comment
Share on other sites

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:)

Link to comment
Share on other sites

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 ?

Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

  • 2 weeks later...

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.

Link to comment
Share on other sites

This topic is 5756 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.