Dynamic View limit view to more than 1 contact column
Hello- With my current system I've setup, I am trying to limit views based on the submitter, but I'd like to also give them the ability to add other users to view and make edits to their own submissions.
With that in mind, I can think of two paths:
- Dynamic View>settings> restrict by current user and add multiple contact columns (Submitter column and Additional User column)... Looks like this can't be done since I'm able to only add one contact column
- Create a calculated field to join multiple contact columns together, then restrict by current user with that calculated column (Submitter and Additional User column), but unfortunately, I don't think there's a calculation that can join multiple contact columns together?
I know that I can create a multi contact field and call it "Access to submission" and the submitter can put their own name as well as other users, but for a good user experience, they shouldn't need to put their own name.
Anyone have a solution for this?