Hi, I'm trying to hide/show some views depend...

Fer_Calvano · 06-13-2018 05:00 PM

Hi, I’m trying to hide/show some views depending on a value in the users table.

I’m in the UX part and in the “show if” box I added following expression as a YES/NO

LOOKUP(USEREMAIL(), 02_USERS.XLSX, UserEmail, Ventas) = True

But by using this the view is shown no matter which is the content of the table.

How should I write the expression?

Thanks!!

Aleksi_Alkio

If your “Ventas” column is an Y/N type, your original formula should work as well. If it’s not working, the reason is somewhere else.

Suvrutt_Gurjar

Also as @Aleksi_Alkio guided , the expression LOOKUP(USEREMAIL(),02_USERS.XLSX,UserEmail,Ventas) works perfectly instead of need for LOOKUP(USEREMAIL(), 02_USERS.XLSX, UserEmail, Ventas) = True

Hi @Fer_Calvano, As guided by Aleksi, for this expression to work , ,please use Yes/No type of column instead of Enum type with Enum values

Yes/No.

Aleksi_Alkio

@Suvrutt_Gurjar You can think the option Show_If like this… It will hide that menu name, but not the view itself.

Suvrutt_Gurjar

Yes, you are right @Aleksi_Alkio

Fer_Calvano

Thanks to both!

Fer_Calvano

Hi, I’ve tried with your suggestion but it is not working…maybe the mistake is somewhere else. Thanks!

Aleksi_Alkio

What happens if you try just… LOOKUP(USEREMAIL(),02_USERS.XLSX,UserEmail,Ventas)

Fer_Calvano

my views have “go to view” behaviour… could this be an issue?

Fer_Calvano

Hi, @Aleksi_Alkio I’ve now changed the Ventas column to Enum, allowing “SI” or “NO” as options. If I run the formula, the answer is “NO”,

but the view is displayed.

Thanks! Fernando

Fer_Calvano

Fer_Calvano

Suvrutt_Gurjar

Hi @Fer_Calvano, A couple

of updates after I did testing based on @Aleksi_Alkio’s guidance and your inputs. You had mentioned that you have “go to a view” behavior in your views.

My testing indicates that if you have a view called say A , you can use the “show_if” condition for that view to block a user from seeing the view FROM MENU or Bottom Header.

However further testing showed was if you call this view A through an action type of “Go to a view”

from another view B,

the view A

is visible through action button to an user even if the user is blocked for that

view A from “show_if”

condition of view.

Hope this helps.

Suvrutt_Gurjar

Hi @Fer_Calvano, A couple

of updates after I did testing based on @Aleksi_Alkio’s guidance and your inputs. You had mentioned that you have “go to a view” behavior in your views.

My testing indicates that if you have a view called say A , you can use the “show_if” condition for that view to block a user from seeing the view FROM MENU or Bottom Header.

However further testing showed that if you call this view A through an action type of “Go to a view”

from another view B,

the view A

is visible through action button to an user even if the user is blocked for that

view A from “show_if”

condition of view.

Hope this helps.

Suvrutt_Gurjar

Hi @Fer_Calvano, You may wish to try the following

In the Ventas column ,please use words like “Allow” or “In Team” when you wish to allow the View to be seen by user and say “Disallow”

or "Out Team"when you do not wish the user to see the view.

Please modify the expression accordingly, LOOKUP(USEREMAIL(), 02_USERS.XLSX, UserEmail, Ventas) = “Allow” or

LOOKUP(USEREMAIL(), 02_USERS.XLSX, UserEmail, Ventas) = “In Team”

The above expression will allow the user to see the views when Ventas column is “Allow” or"In Team" against their names.

Hope this helps.

egmv_appsheet

Just I need a clarification about each term in the expression, and then what is the action accordingly if it added on show if part of the UX

Steve

egmv_appsheet

LOOKUP(USEREMAIL(), 02_USERS.XLSX, UserEmail, Ventas) = “In Team”

Thanks Steve, but in particular I need explanation for the elements in this expression above and what it will do

Steve

The doc explains what they’re for.