hide a column

How do I hide a column only from a specific user?

Solved Solved
0 5 145
1 ACCEPTED SOLUTION

@Francisco1988 I suggest you to follow @MultiTech's method, I have something like that on almost all of my apps (maybe all of them).

In your case, if you consider it overkill or you need a fast solution while you wrap your head around @MultiTech's tip, use a List() expression to add all of the users you want to exclude (or include, depending on your need)

# This is to have a list of allowed people
IN(
  USEREMAIL(),
  LIST(
    "EMAIL1@EMAIL.COM",
    "EMAIL2@EMAIL.COM",
    "EMAILN@EMAIL.COM"
  )
)

# If you need to have a list of unallowed, just wrap with NOT()
NOT(
  IN(
    USEREMAIL(),
    LIST(
      "EMAIL1@EMAIL.COM",
      "EMAIL2@EMAIL.COM",
      "EMAILN@EMAIL.COM"
    )
)
)

View solution in original post

5 REPLIES 5

Assuming that you are requiring your users to login in (or at least authenticate) to use the app, then you can use the USEREMAIL() function as shown below in the Show_If property of your column:

USEREMAIL() <> "abc@useremail.com"

This expression will Show the column for all users except the one specified in the expression.

if it were two users would it look like this?

USEREMAIL() <> "abc@useremail.com", "aaa@useremail.com"

@Francisco1988 I suggest you to follow @MultiTech's method, I have something like that on almost all of my apps (maybe all of them).

In your case, if you consider it overkill or you need a fast solution while you wrap your head around @MultiTech's tip, use a List() expression to add all of the users you want to exclude (or include, depending on your need)

# This is to have a list of allowed people
IN(
  USEREMAIL(),
  LIST(
    "EMAIL1@EMAIL.COM",
    "EMAIL2@EMAIL.COM",
    "EMAILN@EMAIL.COM"
  )
)

# If you need to have a list of unallowed, just wrap with NOT()
NOT(
  IN(
    USEREMAIL(),
    LIST(
      "EMAIL1@EMAIL.COM",
      "EMAIL2@EMAIL.COM",
      "EMAILN@EMAIL.COM"
    )
)
)

thanks!!!!