Hiding particular field in the app based on the user email

AppSheet AppSheet Q&A
,
1

Hi please help me in this, I need to hide particular column in the table according to the user email id signed in the app.

eg. adminl@gmail.com this email id has the permission to view the project cost field.
and for this this email id user@gmail.com the project cost field should be hidden.
what syntax to use .
Thanks in advance,
Praveen

2

A couple of other things that may help here.

When you add users to the app’s whitelist, you can also specify whether they are “Admin” or “User”. Then you can use the USERROLE() function to test which role the logged in user falls into. Unfortunately, these are the only two roles currently supported by AppSheet but this seems to be all you need for now.

To check if the logged in user is a specific user, you can use the USEREMAIL() function. In this case, you test against the email directly IF (USEREMAIL() = "adminl@gmail.com",...

OR, if you need to test against a list of email addresses then you would use the IN() function - article provide by @LeventK above.

4 Likes
3

WillowMobileSystems:

OR, if you need to test against a list of email addresses then you would use the IN() function - article provide by @LeventK above.> > 1X_05f4a2145f98a218028074e420f74174ca35c222.png> help.appsheet.com> >

2X_5_5690c970ab081b6eef071577612e166eee5ace24.png
2X_5_5690c970ab081b6eef071577612e166eee5ace24.png690Ă—388 15.2 KB
> > ### USERROLE()> > Get assigned role of approved user

hello willowmibile,
thank you for your response, the information you gave really helped me in solving the problem.
thanks

2 Likes
4

This might have solved things for you:

[Current_User (Slice) - How to conform your app around WHO is using the app](https://community.appsheet.com/t/current-user-slice-how-to-conform-your-app-around-who-is-using-the-app/35639) Tips & Tricks ?

One of the core basic functions, included in just about EVERY app I make, is the ability for the app to know WHO is using the app. If the app knows who’s using it, then I can easily control many different aspects of the app: Add/edit/delete permissions How data should be filtered What views are shown What buttons, or Actions, are visible Which workflows should fire off Which columns should be shown or editable etc. Requirements To accomplish this functionality in your app, you need the follo…

Maybe if I get enough posts with this solution-post linked to it, people will finally start getting the answer BEFORE they post.

4 Likes