Bug with "From" field in submitted email when using placeholder

[Patrick Karjala]

Just got FormEmailer set up and running, and it's a great piece of work.  Thank you Henrique!

In setting up the email, I have set the Sender Name field to the #Username# placeholder, with the intent that the email sent by the FormEmailer script will be processed as if it was sent from the original form submitter.  The reason is that we have set up FormEmailer to send to our ticketing system, and the "From" field in the email is utilized to automatically register a ticket with a particular person.

The problem is that after multiple submissions, the #Username# placeholder in the Sender Name field is only being replaced with the username in the first submitted result in the spreadsheet, I.E., Cell C2.  As such, all emails appear to be coming from one person, instead of from each person making a submission.  This issue only occurs with the #Username# placeholder in the Sender Name field; it is correctly replaced wherever used in the body of the email.

For example, the if the value in C2 of the Username column is "he...@there.com", and the submitter's email is "pat...@gmail.com", the email will look like this:

From: he...@there.com

Subject: Subject

Username: pat...@gmail.com

Data1:  Data

etc.

Where it should be 

From: pat...@gmail.com

Subject: Subject

Username: pat...@gmail.com

Data1:  Data

etc.

Thank you for any assistance that can be offered.

[Henrique Abreu]

Hi Patrick,

Please take a look: Change of e-mail address?

Regards,

Henrique Abreu

--
You received this message because you are subscribed to the Google Groups "FormEmailer" group.
To unsubscribe from this group and stop receiving emails from it, send an email to formemailer...@googlegroups.com.
To post to this group, send email to forme...@googlegroups.com.
Visit this group at http://groups.google.com/group/formemailer.
For more options, visit https://groups.google.com/d/optout.

[Patrick Karjala]

Thanks Henrique,

Thank you for the additional information.  This does explain part of it, but not the entire thing.  The email address on the account being used is, for example, "tech...@domain.edu".

When we receive the email, it's being received as "subm...@domain.com <tech...@domain.edu>" in the From field.  So for some reason it is appending the "subm...@domain.com" portion to the first part of the email address when we put #Username# in the Sender Name field, and it's only using the first form response in cell C2 to populate this.  Ideally it would use the most-recently submitted form's #Username# data field.

We've gone ahead and removed #Username# from the Sender Name field for now, and have it replaced with genetic text.

Thanks again!

-Patrick

On Thursday, October 2, 2014 10:24:46 AM UTC-10, Henrique Abreu wrote:

Hi Patrick,

Please take a look: Change of e-mail address?

Regards,

Henrique Abreu