Make a line (information) only visible for one group

[Frank0]

Hello Community,

I am brand new to the AppSheet topic and am just starting out.
Is it possible to make one or more rows in a spreadsheet visible only to a certain group of logged-in users and how should this be set?
Example: on a page in the app, there is information for the IT area, but the sales area does not need to see it. And so I would like to hide rows 5 and 6 for the sales area, for example.

Is that possible? Many thanks for the information or perhaps a link.
Frank

[WillowMobileSys]

---

@Frank0 wrote:

Is it possible to make one or more rows in a spreadsheet visible only to a certain group of logged-in users and how should this be set?

---

Yes.  To accomplish this based on your example, you will need a Users table where you can determine the logged in users' group.

There are two ways to filter rows:

1)  Security Filters - preferred way - these are expressions that filter the data downloaded to the device/desktop.  If the user is in Sales group then only Sales related rows are downloaded so there is no chance of this user even seeing other data.  This also eliminates the need to sprinkle filtering logic all over the app.

2)  Slices - these are subsets of the data table created AFTER download.  You would then use the Slice in the View

PRO TIP:  The data a Sales person would see versus what an IT person would see is usually wildly different.  It may be more feasible to have 2 separate apps.  A user can access any number of apps with a single license and they can share the same datasource.  The disadvantage is that any shared  data and/or features that are shared would need to updated in both apps.  An advantage is that you can make assumptions that allow the implementations to be easier and less complicated.

I hope this helps!

[Steve]

Security filters: The Essentials

Slice row filter conditions