I have an object that needs to be hidden when a two fields return specific results.
For example: I have a book named Book 1 (in a list of various books), and when the Book Name field says "Book 1" and the Status field says "Checked Out," this object should disappear.
I have tried entering the following into the "Hide Object When" field, but it is not functioning as expected.:
(Book List::Book Name = "Book 1" and Book List::Status = "Checked Out")
It almost seems like I should have to run a script to perform a find for "Book 1" and "Checked Out" before it can return a true result and hide the object.