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.
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
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |