Order of operation, loading a form and show if exp...

Lucinda_Mason · 05-13-2020 12:34 PM

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.

Steve

A view’s Show if only affects the view’s inclusion in the main menu or navigation bar along the bottom of the screen; it does not prevent the user from viewing the view content if the user gets to it by other means (e.g., navigation action, or direct URL).

When you say, “I have one item that I do NOT want to show”, what “item” are you referring to?

Lucinda_Mason

In this case, I don’t want the last form (#control=Submit_Encouragment) to show for a certain class of users. In this table, PI_NO=0 means to show for ALL users, regardless of their actual PI_NO. I want to keep this particular form from showing to PI_NO=8.

Steve

You don’t want the action button that navigates to the form to appear? To show or hide an action button, use the action’s Only if this condition is true expression.

Lucinda_Mason

That makes sense, but I don’t want the line item to even display. So even if I modified the Only If the condition, that would just keep it from doing anything when clicked, correct?

The action is used for each row in my table. This is what the launcher deck view looks like:

This is the Row Selected action.

This is my action.

So I’d have to limit the action to NOT RUN, JUST for that single form under the PI_NO=8 condition. Is that correct? I can’t somehow attach it to the form view I don’t want shown?

hru

Will it be possible for using a slice for that “row” launcher no?

Lucinda_Mason

@Heru Brilliant idea! I’ll give it a try.

hru

Hmmm, not really. Better to review this first before decide to go that path. See “Can slices be used instead of a security filter?”

Order of operation, loading a form and show if expression?