Dynamic View - Sharing with multiple emails & Restrict View
I am using Dynamic View to share records with multiple external businesses. The sheet I am using as a source has thousands of records, but I have restricted the view by the current user using the Primary Business Contact email for each of the businesses so that they can only see the records associated with their business.
My question is, if I have already restricted this view to the business contact (which is a contact column from the sheet) do I still need to add the emails from each of the business contacts to the Shared Users list? If so, how can I add multiple emails at one time? If I copy/paste the list from the source sheet I just get one long running email, not separate emails. I can't imagine there is not a way to do this without adding a hundred separate emails manually.
Also, why is there no way to preview a Dynamic View? I do not love having to add a dummy record for myself just to make sure that everything is working 🤨