Solved: Filter Row Condition with userrole

Mas_Syahdan_Fil · 04-20-2021 11:59 PM

hy dear, i wan’t to make slice with row filtering.
but i will add condition with userrole akses
can you help me for this problem?
thanks

google upload gambar

hru

you can use security filter for the table with expression as below:

OR(
	(USEREMAIL() = [EmailColumn]), 
	(USERROLE() = "Admin")
)

View solution in original post

hru

It will be depend on what kind of filtering that you want.

Slice Row Filter Conditions | AppSheet Help Center

USERROLE() | AppSheet Help Center

and you can also create a new table for the userrole.

Mas_Syahdan_Fil

i will try it
but i stuck in condition appsheet
can you help me?

Mas_Syahdan_Fil

i will stuck if else for this condition
if user login with user role user >>> can view data only for this maill user
else
view data for all
can you help me?

hru

you can use security filter for the table with expression as below:

OR(
	(USEREMAIL() = [EmailColumn]), 
	(USERROLE() = "Admin")
)

Mas_Syahdan_Fil

not work

hru

have you shared the app and assign the role to those emails?

Mas_Syahdan_Fil

like this?

hru

yes. And where did you place the expression?

Mas_Syahdan_Fil

in this

and my view

hru

Hmmm I did not see anything wrong about the setup.

One last try: please check the security for required sign-in is as per below picture:

adn do re-sync:

edit: and make sure you are on core subscription.

if still not working, perhaps other may spot the issue or you might need to contact appsheet to let someone check by looking to your app.

Mas_Syahdan_Fil

hi dear,
i will delete my cache, dan refresh my app
and this problem as solved
thanks