chiggins68 Posted October 27, 2015 Posted October 27, 2015 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
Lee Smith Posted October 27, 2015 Posted October 27, 2015 See if this does what you want. ReportEnter 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 ModeGo to Layout [ original layout ]
comment Posted October 27, 2015 Posted October 27, 2015 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. 1
chiggins68 Posted October 28, 2015 Author Posted October 28, 2015 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!
comment Posted October 28, 2015 Posted October 28, 2015 By "only" it meant that here are different types of hard drives tracked. Well, the way you put it, it could be understood as either "only computers with SSD drives" or "computers with only SSD drives" - which is very different.
Recommended Posts
This topic is 3574 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 accountSign in
Already have an account? Sign in here.
Sign In Now