3guk Posted March 27, 2015 Share Posted March 27, 2015 Hey Guys, I've got 3 filtered portals on one of my layouts with each portal showing related records based on :- Events::Status = "Drive" Events::Status = "Build" Events::Status = "Event" Now what I'd like to do is hide the portal if there are no related records that match each one of the conditions. I plan on using the "Hide Object When" function of the new filemaker, however can't quite work out the calculation required. Is anyone able to point me in the right direction for the calculation required to count if there are any related records that have each one of the conditions as mentioned above ! James Link to comment Share on other sites More sharing options...
comment Posted March 27, 2015 Share Posted March 27, 2015 the calculation required to count if there are any related records that have each one of the conditions as mentioned above ! Try = IsEmpty ( FilterValues ( "Drive" ; List ( Events::Status ) ) ) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3315 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