I'm trying to do something that SHOULD be fairly simple. I want a form that someone can fill out that emails a distribution list (e.g. list (at) [url removed, login to view] ) with the form data, but have the replyTo address be the person who submitted the form.
Originally I tried to do this using a Google Script (see attached file) but I can't get replyTo to work. It just keeps setting the recipient's email as the replyTo (which is the default value) Doing this with Google Script would be ideal because we could use a Google Form which then logs to a Google Sheet so we could track form fills, but that was just my initial plan. I'm open to any solution that would accomplish this. Ideally I'll want to limit access, but I can park it on a password protected page if we come up with something embeddable.
The Google Form I had created was here, in case that's helpful: [url removed, login to view]