Hey guys, I'm wondering if someone could give...

(Bernardo Bastos M. Pinto) #1

Hey guys, I’m wondering if someone could give me a hand.

I made an app to manage a small team of sales. They can all add leads, but they can only see their own leads and the ones that are unassigned (by use of security filters).

I’m trying to figure out a way to let them view the NAME of the lead that is assigned to somebody else, but no other information.

Any ideas? Thank you in advance B

(Fernando López) #2

Did you consider to use SLICES? Just use the columns you need to show

(Aleksi Alkio) #3

@Fernando_Lopez If he is using the security filter for that table, the slice won’t help.

(Aleksi Alkio) #4

Or did I misunderstood this? What records the user is actually seeing?

(Bernardo Bastos M. Pinto) #5

I was indeed trying to limit the amount of data sent/available for each user.

If the slices can be set per user, slicing everything and eliminating the filters might be a simple solution, as I’m not so worried about the data being hidden but available.

I’ll give it a look and get back to you guys. Thank you indeed.

(Aleksi Alkio) #6

One way is an additional read only table with a name field only. You can read the column with an Arrayformula or Query if you are using gSheet as a backend.