How can I show data as per user id

AppSheet AppSheet Q&A
,
1

I have a sheet where sales person name is mention with their assigned brand:-

Item ID Item Name Brand Sales Person
835789000000014648 Red Bull ED 330 Ml Red Bull Sales Person1
835789000000014657 Red Bull ED 350 Ml Red Bull Sales Person1
835789000000014666 Red Bull ED 250 Ml Red Bull Sales Person1
835789000000014675 Red Bull ED Red 250 Ml Red Bull Sales Person1
835789000000014684 Red Bull ED Sugar Free 250 Ml Red Bull Sales Person1
835789000000014693 Red Bull ED Sugar Free 330 Ml Red Bull Sales Person1
835789000000014702 Red Bull ED Yellow 250 Ml Red Bull Sales Person1
835789000000019046 Apple Juice 1 Ltr Dabur Sales Person2
835789000000019055 Real koolerz 2 Juice 125 Ml Dabur Sales Person2

Now, I want when a sales person is filling order form having (Sale Person, Order Id, Brand,Item,QTY), Only their linked brand and item will shown.
For example when sale person filled Sales Person 1 then in Brand col only Red Bull will show.

2

Hi @Fabhoreca

You may want to use the valid_If expression of the Item.

This is a dependent-dropdown.

Drop-down from Valid_If - AppSheet Help

You may need to use this expression:

FILTER("Item", 
  [Sales Person]=USEREMAIL()
)

Reference: FILTER() - AppSheet Help

Or, even more efficient: use a security filter, so that the Sales Person can only access the item that matches the assigned brand.

For reference:

Security filters: The Essentials - AppSheet Help

1 Like