Column filter

[Alvim]

Hi

In a table, I have the columns Id, Account name, Salesman.

How could you create a filter control to view only the Account Name associated with the Salesman?

Tks

[Marc_Dillon]

Wouldn’t each record already give a single association between account name and salesman? What exactly are you wanting? Maybe you want to “Group By” Account name?

[takuya_miyai]

@Alvim

Marc_Dillon:

Maybe you want to “ Group By ” Account name?

Or do you need a screen for each sales rep, such as “my account”?

[Alvim]

Exactly. Each salesperson will be able to view and edit, only the records that are in his domain.

[Marc_Dillon · Accepted solution]

help.appsheet.com

Limiting Users to Their Own Data

You can use Security Filters to control which records a user can see and update.

Current_User (Slice) - How to conform your app around WHO is using the app 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…

[Alvim]

Thanks @Marc_Dillon and @Takuya_Miyai for the tips

In the table with the data I wanted to filter, I inserted an email column.

Then I created a Slice for the Current User and indicated that Slice on UX, For this data