I have a Deck View I call Launcher. It gets data from a table based on a value from my Users table. That all works perfectly.
I have one item that I do NOT want to show to a certain user (PI_NO=8, but do want to show it to PI_NO=1-7 and 9.
I tried adding the following SHOW IF
IF(LOOKUP(USEREMAIL(), “Users”, “USER_EMAIL”, "PI_NO”)=8,FALSE,TRUE)
Could it be because the the SHOW IF is being evaluated BEFORE the control from table is being read?
Thanks for any ideas.