AnsweredAssumed Answered

Check if Filtered Portal is Empty

Question asked by TurtleKoala on Sep 6, 2012
Latest reply on Sep 6, 2012 by TurtleKoala

Title

Check if Filtered Portal is Empty

Post

I am trying to use conditional formatting on text based on whether a portal is empty. The portal contains a field called Test::Description and is filtered based on the field Test::Category for the value CatOne. I tried using

IsEmpty(Test::Description)

but as I expected, this checks if there are any records with a description, not just records with Category CatOne. I also tried

IsEmpty(Test::Description) and Test::Category = "CatOne"

but not surprisingly this doesn't seem to work either.

I suppose I could create a calculation field in Test that is based on description and category, but this database was created with a lot of extraneous fields, so I try not to add more fields if I can help it.

Edit: Also, I am going to be doing this for four different portals filtered by "CatOne" "CatTwo" and "CatThree" and "CatFour" so I think I would have to create four new calculation fields if I were to go that route.

 

Thanks

 

Eric

Outcomes