Connecting different users to same sheet in appsheet

[newbie]

is it possible to make an app using AppSheet where multiple users access data from the same google sheet but the visibility and ability to update is limited … let’s say there is a user with email ID ABC he can only see and update the first 3 columns …DEF can only see and update next three columns something like that.
pls be as elaborate as you can , i m a newbie
thank you for your time

[Aurelien]

Hi @newbie

Yes, please have a look here:

help.appsheet.com

USEREMAIL()

User's email address

help.appsheet.com

Show_If Column Constraint

Conditionally show or hide a column value.

Practically, this is where you can set this:
clik here:

then type that:

You can do the same on this field:

[newbie]

where do i find this section to insert these conditions …i m sorry i know this is really stupid question but i m just getting started with appsheet

[Aurelien]

[newbie]

i cant thank you enough …really thank you

[Aurelien]

You are welcome
Feel free to refer to the documentation on help.appsheet.com sometime, it is really helpful !

[newbie]

thanks a lot you are a life saver