Well if the user can never see another user’s email then I don’t think there’s a way. You would have to use an integration like Make/Zapier, send an unidentifiable piece of info like rowID, then search for the real email address in Make/Zapier using that rowID, and send the email.
Just wondering why can’t we use Glides native send email button in this case, and on user profile add a USC email body and a button for user that says Send Email? We can hide email from user profile. Just have the button visible so another user can type the text on USC column and press send button.
How do you get the email to send to in that case? If you are able to reference it in the button, then it’s exposed if any users can log in and have a deep dig to get the data. It’s downloaded to their device.