Just a couple of things to point out. My original suggestion does not require the use of Per User Data, but there would be no restrictions in what a user can see. If you don’t care who sees data, then I think you can accomplish what you want with the use of references. Keep in mind that you can use an array of references. If you need to restrict who sees what data, using Per User Data is still an option. Using an array of emails, you can give multiple people access to the same record (lead). Without seeing your sheet, it’s hard to picture what you want to achieve. I’m just giving my personal opinion of how I would like it to flow. I think having multiple tabs at the bottom of the app, that can dynamically change, can be a bit of a headache when you have to modify the app for each new sheet you create. If you have a simplified version of your sheet, along with a more detailed explanation of how you expect the app to work, I think we could get you set up pretty easily.
1 Like