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) [login to view URL] ) 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: [login to view URL]