Array returning incorrect results - help please!

Ask for Help
1

Hi,
I have one sheet that is using a relation column to pass over a number of services from a different tab.
The relation function works fine and lists the services I have listed in an array from the other sheet.
However when I am using the app, if I am logged in as the second person shown on the screen shots I am seeing the service options for all of the users.
All of the screens have the visibility set to show options for logged in user.

I’m pretty sure this is user error so any help appreciated!

Untitled
Untitled812×1232 53.9 KB
Untitled 2
Untitled 23892×338 88.7 KB
Untitled 3
Untitled 33146×214 60.7 KB

2

I think I have figured it out. Although the visibility is set to only show signed in user, I have to set a filter to also only show items for a signed in user as-well.

As I said - User error!

1 Like
3

A filter will filter the data based on the condition you set. Visibility simply determines if the entire component is displayed or not.

1 Like