PDA

View Full Version : Hiding Emails and sorting groups from Google Forms Survery



JustinTime
07-14-2018, 09:05 PM
I am doing a study that will last a good year. I have to believe there is a way to hide the emails that are entered into the email column from the survey. I need the emails to come in so that I can have the responses sorted into their respective groups but for ethical purposes I cannot know who actually responded in what way. I was also hoping to add the vlookup (how Im sorting emails into groups) to the code for hiding the emails from my and other users eyes. I searched the internet and have tried playing around myself for over 4 hours now, I need help. Hope that makes sense.

22560

The Emails in this are of course fake so assume they look like normal emails.