I have created a survey using Airtable and then an automation which triggers an email to be sent once the survey is completed. It's all working great. However, I don't want to save, store or have access to the information that is inputted into the survey. I just want people to be able to complete the survey - which will automatically generate the desired email and send it out on their behalf - but without me as the creator having access to their answers.
I don't think so I'm afraid. Even if you used an automation to delete a record once it's created that record will still technically be available in your base's trash, so you'd technically always have "access" to it until the trash clears itself. Not sure when that is, hopefully someone else can shed some light