Hi,
I want that when [Channel] column has Jiomart and equal of users, then the details of [Order] column of Jiomart should be hidden.
But when there is admin at, then [order] column’s detail should be shown. Please help.
What is “Jiomart”? And what do you mean by “equal of users”?
How are you assigning “Admin”? Are you using AppSheet user assignment or did you build your own user roles?
I mean to say that if there is a Jiomart inside the channel, then it should not be visible to the users of the columns.
Ok, so I’ll read between the lines…
…I THINK you are saying that the [Channel] column is an EnumList where a user can select multiple options. “Jiomart” is one of those options and if that choice is in the selected list, then the [Order] column should be hidden UNLESS the user is an Admin.
I will also assume you are assigning “Admin” in the AppSheet Editor.
With the above understanding, you would use this expression in the Show_If of the [Order] column:
OR(
NOT(IN("Jiomart", [Channel])),
USERROLE() = "Admin"
)
Showing error
Show More
Parameter 2 of function IN is of the wrong type
No I’m using refrence sheet
This means that [Channel] is NOT of a list type and my assumptions made in the previous post were wrong.
We need some screenshots of the columns you are dealing with in the app.
Also, I still don’t understand what “Jiomart” is. Is it a column value? And if so, what did you mean by this…“if there is a Jiomart inside the channel”. Do you mean if the {Channel] column EQUALS the value of “Jiomart”?
YES! This helps! Though it would have been helpful to also include the Permission table definition.
I will assume the name of your table with the User Types is called “Permissions”. And I will assume that the [USER TYPES] column only allows for a single value - i.e. its another ENUM type column.
The adjusted expression would be:
OR(
[Channel] <> "JIOMART",
ANY(SELECT(Permissions[User Types], USEREMAIL() = [Control Mail])) = "Admin"
)
I hope this helps!!
1 Like
One more condition has to be added to this.
I want that if [Channel] has “Reliance” and Equal [Couriers] has “ECOM”, then this column should also be hidden.
Both Columns Enum Types
Hi @WillowMobileSys please help