Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

Hello, thank you for your inters in my topic!

 

I'm looking for some help on hiding record titles. In list I have a sub-summary with client name in it. I also have the client name in the body. When list is sorted and the sub-summary is in use I would like to hide the client name in the body.

Any Ideas on how to do this or if it can be done???

 

I've attached screenshot to help illustrate the issue.

 

I'm guessing I could use some conditional formatting, make the text color the same as the background, etc...

 

Any help would be appreciated, THANK YOU!

post-80154-0-59958900-1370882927_thumb.p

Posted

Take a look at the Get(SortState) function. You can make your conditional formatting set to a font size of 500 when sorted.

  • Like 1
Posted

Yea, this was the idea, tho I do not know how to code it up.

I will have more then one sub-summary part and I will need to tie a specific title hide to a specific sub-summary sort.

Something like this...

 

Conditional formatting formula:

 

 
If(
(Get ( SortState ) Sub-summary#Client) = "sorted"; 1
)
 
haha... don't laugh  :jester:
Posted

Well if you have multiple subsummary parts, you can use something like:

 

GetSummary ( zzs_kount; FirstBreakField )

 

GetSummary ( zzs_kount; SecondBreakField )

 

 

 

This is where the zzs_kount field is a summary count field that I usually use on the ID, and the FirstBreakField / SecondBreakField are the fields you are sorting / breaking on with the report.

This topic is 4240 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.