Jump to content

Making an Object Visible based on portal results.


etsmarines
 Share

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

Recommended Posts

I have a table called Services

 

I have another table called Versions.

 

This table services has a portal into the Version table and shows all software versions associated to a given service. So for example if I am on Service A the portal window shows all Versions of software that are part of that service.

 

I have conditional formatting setup so that a version row is out of date in more than a year it is filled in green

If it is out of date in less that 6 months it is filled in Amber.

If it is already out of date it is filled in Red.

 

It looks at the support date field and compares it to the system date and colors it accordingly.

 

Some services show lots of record in the portal with greens and reds and ambers...some with all red.... some with all green... some with all green and maybe on one red.

 

I want to create a quick score card at the top of the Service Page that says if any fields in the portal are red it will show  a red square at the top of the layout no in the portal. If any are green it will also show a green square on the layout at the top and the same with the amber. 

 

So i want to be able to scroll through the services layout and see a possibility of Green, Amber or Red or a combination of the three depending on what the conditional formatting looks like in the portal.

 

The question is.... how to do it.... thanks again! 

 

Link to comment
Share on other sites

The question is.... how to do it.... thanks again! 

 

One approach would be to move the status calculation out of the CF and into the Versions table, where e.g. in the unstored calc field

 

Versions::statusCode

 

you'd combine the calculations from the CF, but now resulting in a text value instead of a Boolean, e.g. "C", "B", "A".

 

Use this field for the CF of the portal row (Versions::statusCode = "A" …etc)

 

To produce your score card, an expression like

 

PatternCount ( List ( Versions::statusCode ) ; "A" )

 

and "B", "C", respectively, will give you the Boolean result to show/hide the colour boxes. 

Link to comment
Share on other sites

This topic is 2633 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

  • Who Viewed the Topic

    2 members have viewed this topic:
    iLoveFMS  comment 
×
×
  • Create New...

Important Information

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