Display the specific rows by specific users

Ask for Help
1

hello.
i want to Display the specific rows by specific users.

sheet “groupUserList " has groups and users.
oooooooooooooooooooooooooooo
Sheet"groupUserList”
group user(unique)
A aaa@aaa.aaa
A bbb@bbb.bbb
B ccc@ccc.ccc
oooooooooooooooooooooooooooo

sheet “Products " has product and group.
oooooooooooooooooooooooooooo
Sheet"groupUserList”
rowid group products price
1 A pencil $200
2 B apple $100
3 A pin $10
oooooooooooooooooooooooooooo

i want to display rowid 1 and 3 if user aaa@aaa.aaa login
oooooooooooooooooooooooooooo
display window
products price
pencil $200
pin $10
oooooooooooooooooooooooooooo

2

Create a Relation column in the Products sheet to link Group in the Products sheet to Group in the groupUserList sheet. Then create a Lookup column that uses the relation to get a list of emails from the matching group. Set a filter on the products tab to signed in user.

3

wow, thank you for your answer.
i can do it!!
Displayspecificrow.glideapp.io

1 Like