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. 👍️