Jump to content

Conditional Formatting on Report


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

Recommended Posts

I'm using Filemaker 11.

I have a table called Computers with fields:UID, Computer Name (MacBook0001, MacBookAir00002 ect.) this is a parent of the Hard Drives table which lists Hard Drive size and Hard drive type (SSD, or SATA) along with UID. I have a portal on the Computer layout which lists Hard Drive size and type that were assigned to the computer on the Hard Drive layout. I have setup basic report just listing the Computer name. I want to setup a conditional formatting on the report layout to color the computers name that only contains an SSD.

test.fp7

Link to comment
Share on other sites

See if this does what you want.

 

Report
Enter Browse Mode

Go to Layout [ “Hard Drives” (Hard Drives) ]
Set Variable [ $SSD; Value: "SSD" ]
Enter Find Mode [ ]
Set Field [ Hard Drives::Hard Drive Type; $SSD ] Perform Find [ ]

Sort Records [ Specified Sort Order: Computers::Computer name; ascending ] [ Restore; No dialog ]

#Go to Preview mode for earlier versions which do not support summary reports in Browse mode.

Enter Preview Mode

[ Pause ]

Enter Browse Mode
Go to Layout
[ original layout ] 

Link to comment
Share on other sites

I want to setup a conditional formatting on the report layout to color the computers name that only contains an SSD.

Not sure what exactly you mean by "only". Using this as the formula for conditional formatting =

not IsEmpty ( FilterValues ( "SSD" ; List ( Hard Drives::Hard Drive Type ) ) )

will format any computer that has at least one SSD drive.

  • Like 1
Link to comment
Share on other sites

By "only" it meant that here are different types of hard drives tracked. Those that are SATA and those that are an SSD. This report is being used to review equipment and decide whether we want to upgrade our equipment from spinning disks (SATA) to SSDs.

Thank you for your help!

 

Link to comment
Share on other sites

This topic is 3064 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
×
×
  • Create New...

Important Information

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