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 4111 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I want to recreate the Show all Records button (with text) on my layout.  What's the script behind the conditional formatting?  When all records are showing the icon is grayed out.  If I use text in place of the icon how do I gray out the text when all records are showing?

Posted

I'm not articulating my question correctly.  If the total records equal 4 and I do a Find resulting in  only 2 records I want my button text to be grayed out.  When I use Get(FoundCount) and or Get(TotalRecordCount) it returns 4 (regardless of my Find result).  How do I identify the resultant number of records from my find?  Maybe I'm using it wrong. Can you advise?  My user name and password on the attached is admin.

 

 

FoundCount.zip

Posted

When I use Get(FoundCount) and or Get(TotalRecordCount) it returns 4 (regardless of my Find result). 

 

 If your found set contains 2 records, then Get ( FoundCount ) returns 2. You would see that in your file too if you only set the calculation fields to be unstored.

 

 

In any case, you don't need the calculation fields for conditional formatting; just set the button text color to change to grey when =

Get ( FoundCount ) = Get ( TotalRecordCount )

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