Dynamic View- using multiple contact columns to restrict access

Kernesa Samana

I have a dynamic view that used to give access based on two columns (if you were in the Contact or Back Up Contact - you could see that row). 

On Tuesday this functionality was no longer working (the page would not load for anyone) and I went in to fix it and had to select the restriction just on one contact column- I cannot select two. When I google this, it appears that this has been the functionality all along. 

Does anyone know if something changed, or a work around for this?

Paul Newcome

Apply a filter to the sheet and then you can select that filter in the Dynamic View.

Paul Newcome

Apply a filter to the sheet and then you can select that filter in the Dynamic View.

CWS_Bob

@Paul Newcome If I am reading this right, then this solution only allows for just one person to so see the row, correct?

If I filter the view in the sheet as suggested I have to allow visibility of all rows to all parties filtered

I need to have multiple contacts be able to view their specific rows.

i.e.

emails of:

person1, person2, person3

manager1, manager2, manager3

Leader1

Row visible to:

1 Person2, Manager3, leader1

2 Person1, Manager1, leader1

3 Person3, Manager3, leader1

CWS_Bob

If I could use a formula to dynamically add multiple contacts to a contact column that would a solution that would work for me I think

Paul Newcome

You would set up a filter in the sheet itself similar to the screenshot below. You can then apply that filter within the Dynamic View.

CWS_Bob

Thank you for the details ... That worked out better than expected and was super easy to follow! Huge Thanks!😁

Paul Newcome

Happy to help. 👍️

MarieM

@Paul Newcome , is there a way to do this if the source is a report?

Paul Newcome

@MarieM You would set up the report with the filter. The Dynamic View wouldn't need an additional filter because it is only going to display what is shown in the report to begin with.

MarieM

I'd like to allow the user to see a row if they're assigned in any of 3 columns in a report (each column comes from a different sheet). I don't see the option for filtering out viewer/user in the report. @Paul Newcome

MarieM

sorry, @Paul Newcome , I see i can select "has any of" "current user. Thank you!