I am trying to control when a specific menu view (Generate Report) is visible based on the data in one table (ExpensesTable) of my app. The criteria is if data for the current user exists in the table with a “Status” of “Open” I would like the view to be visible. If no “Open” Records are in the table for the specific user I want to hide the view. I have tried the following Lookup statement in the “Show If” of the “Generate Report” view which uses a Virtual column(Employee Email Address) in the table that connects the email address of each record to the current user.
Show If Statement:
LOOKUP(useremail(),“ExpensesTable”,“Employee Email Address”,“Status”)=“Open”
Using the above, I have records that meet the criteria but the view remains hidden. I have tried the above statement within an IF statement as well with the same result.
Clearly I am missing something or trying to accomplish this using an incorrect approach. Thanks in advance for any assistance.