@George_Lewis1 Thank you! The method I’ve used has worked well for me and others in the past, but as you’ve noticed in the other thread, I do understand how you method works now, so no need for a sample app. I do thank you for putting this thought process in my head. It definitely opens up a lot of opportunities to pull back much more data, per user, than just an array of emails. As you’ve noticed, there’s the potential to display all kinds of user specific data from other sheets or use it for filtering and visibility and I suppose it allows for passing those values into a form as well which could really be beneficial. I’m sure I’ll be referring to this much more from now on.
It will be interesting if you run into any scaling issues down the road. I suppose your method is much more efficient since you are only pulling back relevant data as opposed to the massive list of emails.
Again, thank you for this.