I'm currently trying to create a view that dynamically filters which records are visible to the user depending on the company the view is being used for.
If jack wants to have informative emails tied to a particular company sent to a specific user, then a drop down list with the names of the users specifically tied to that company should be available to choose from.
If jack then went into another company's settings and wanted to set up another user to receive emails, the same drop down should then only display users belonging to that company.
My thought is that the drop down list should be populated by a view with all users, and then the users that show up when running should be filtered using a formula. Can this be done this way? What might the formula look like if so? The formulas I have been writing so far either error out, or populate all or none of the users without filtering them.