How to send alert without allowing access to sheet
Hi, I have a workflow where user #1 fills out a form, and one of the fields is a contact field where they enter the email for user #2. Then I have an alert that goes out to user #2.
However, when the alert goes out to user #2 it gives them access to the sheet and it also shows a log of activity on the sheet. I do not want user #2 to get anything except the notification content in the alert, and I do not want them to get access to the sheet.
Any help on how to do so would be much appreciated!