SHOW IF for View

[Domearian]

Hi All. I want to look at a different table to decide if a view should be shown or not. I am using this:

LOOKUP(USEREMAIL(), Users, Email, SIN MGR) = “Yes”

So if in table Users, using the USEREMAIL() to check the table against the registered email address, if their setting for Sin MGR is "Yes", I want the view to show. But it isn't making a difference. 

[JuneCorpuz]

---

@Domearian wrote:

LOOKUP(USEREMAIL(), Users, Email, SIN MGR) = “Yes”

---

Are you putting this condition in the Show If of the view?

[Domearian]

I am yes. I must point out that the Position is a Ref. It works perfectly as any other part, just not as a ref.

[JuneCorpuz]

Can you please expound this?

[Domearian]

I have a UX view with a view name "SOR Results Menu".

That UX view type is Card. The Position is set as "Ref". So it is referenced and called by an action.

That action is called "Menu Data". When activated, it simply looks at the column called [Menu Item] which lists the UX View to view which is why the Position is set at Ref.

In the Display section, I want it to only show if: LOOKUP(USEREMAIL(), Users, Email, SIN MGR) = “Yes”

But it doesn't work. I am starting to think that "Show If" item is only for the icon, not the actual view. I state why. If someone entered that view and then saved that current URL, they could always enter that view without the need to click on the menu icon. So if you did remove someone from that view, they can still access it via the saved URL, by passing that even if the icon is removed for them at a later date.

So how can I stop someone viewing that view if using a Ref position?