AnsweredAssumed Answered

Hide button when a field in a related table is not empty?

Question asked by ezeitgeist on Mar 16, 2017
Latest reply on Apr 4, 2017 by ezeitgeist

I have 2 tables (User table & B Table) linked by User_ID.  B Table has its own serial_ID and Location_ID.

 

I want to hide a button when the Location is looked up and a related record already exists for that Location (I have an Auto-filtering Search Portal setup and when a portal row is selected, a $LocationID variable is stored).

 

My thought was hide object when: User table::User_ID = B Table::User_ID and B Table::Location_ID=$LocationID and not IsEmpty(B Table::serial_ID).

 

But when I put in the above it just stays hidden the entire time. Where is my error?

Outcomes