How do I set it up to email myself and a different person each time...

[danmightbe]

Ok firstly this is the closest piece of script I can find to solve my problem - I have no programming skills whatsoever so to even get to the point that I've installed it and it's working is an achievement - this stuff is like magic to me and I am not worthy. I throw myself on your mercy and hope you can help me. 

What I'm trying to do is as follows:

Journalist fills out form:

- First name

- Surname

- email 

- What show do you want tickets for? [drop down list]

- What date [drop down list 1 to 25]

- Which media outlet do you work for? 

Confirm. 

This is the Edinburgh Festival, on our roster are 130 shows a day for 25 days. Each with a different point of contact and therefore a different email.

What want is for the form to mail the correct person ( I have all the address) depending on which show was selected from the drop down in the form - I also want it to notify me that the form has been filled in.

Please please help.

Many thanks.  

[Henrique Abreu]

You can do this without coding at all. All you need to do is setup a vlookup formula (or a match-offset pair) to retrieve the email address based on the answer. Place this formula on row 2, in a new column after the last question, call it "recipient" (Your formula must have proper locked references where required, so it can be "dragged" down and correctly retrieve the results).

Then on FormEmailer > Settings. Clear the "To" field, then pick the "recipient" column on the placeholders dropdown, then click the blue "Insert placeholder" link to add it to the To field.

Now, on the advanced settings tab, you have to set the Formulas location parameter, informing the column(s) on your spreadsheet that hold formulas, just so FormEmailer can copy and apply them automatically whenever a new form is submitted. Let's say, for example, that your sheet is called "Form Responses" and that the new "Recipient" column is "H". Formula location parameter should be: Form Responses!H:H

Sounds difficult? I think you can manage it :)

Please let me know.

Kind 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.

[danmightbe]

Hi – thank you very much for you help so far.

 If I could indulge your time for a little longer – I’ve made progress but we’re not quite there yet.

I followed the instructions and will now send an email to me and an email to the ‘show’ email – but it only does it if I hit Form Emailer / process Manually and then pick the row. (if flashes up quota reached or something).

The sheet populates just fine, but it only runs the V lookup and send emails if I do it manually. 

Any ideas?

Currently it’s set up as follows

3 Sheets tabs:

a)Form Responses 1

As per the Questions, with Vlookup Column H

b)Lookup Tables =

Column A Show 1, Show 2, Show 3 etc

Column B email 1, email 2, email 3, etc

c) Form Emailer = the instal notes etc

Settings

Email 1

Sender name: FormEmailer

To: #Lookup#

Subject: Press Tickets Request

Body:

Submitted values:<br>

<b>Timestamp: </b>#Timestamp|M/d/yyyy H:mm:ss#<br>

<b>First Name: </b>#First Name#<br>

<b>Surname: </b>#Surname#<br>

<b>Publication: </b>#Publication#<br>

<b>Show Title: </b>#Show Title#<br>

<b>Show Date: </b>#Show Date#<br>

<b>Lookup: </b>#Lookup#<br>

 

Email 2

Sender Name: FormEmailer

To: my email

Subject: New Form Submitted

Body:

Submitted values:<br>

<b>Timestamp: </b>#Timestamp|M/d/yyyy H:mm:ss#<br>

<b>First Name: </b>#First Name#<br>

<b>Surname: </b>#Surname#<br>

<b>Publication: </b>#Publication#<br>

<b>Show Title: </b>#Show Title#<br>

<b>Show Date: </b>#Show Date#<br>

<b>Lookup: </b>#Lookup#<br>

Advanced Settings

Form Sheet: Form Responses 1

Qtt Emails: 2

Quota Warning: 150

Quota Limit: 30

Formulas location: Form Responses 1!H:H

Closure mode: values

Remaining Quota 92

On Thursday, July 17, 2014 11:58:19 PM UTC+1, Henrique Abreu wrote:

You can do this without coding at all. All you need to do is setup a vlookup formula (or a match-offset pair) to retrieve the email address based on the answer. Place this formula on row 2, in a new column after the last question, call it "recipient" (Your formula must have proper locked references where required, so it can be "dragged" down and correctly retrieve the results).

Then on FormEmailer > Settings. Clear the "To" field, then pick the "recipient" column on the placeholders dropdown, then click the blue "Insert placeholder" link to add it to the To field.

Now, on the advanced settings tab, you have to set the Formulas location parameter, informing the column(s) on your spreadsheet that hold formulas, just so FormEmailer can copy and apply them automatically whenever a new form is submitted. Let's say, for example, that your sheet is called "Form Responses" and that the new "Recipient" column is "H". Formula location parameter should be: Form Responses!H:H

Sounds difficult? I think you can manage it :)

Please let me know.

Kind regards,

Henrique Abreu

[danmightbe]

Just to add - I just tried adding a trigger: Time Driven / From Spreadsheet / on form submit 

It ran it automatically but then sent me a whole load of empty emails every few seconds and populated the sheet cells with:

Error sending email1: Exception: Invalid email: #N/A; Email2 sent

[Henrique Abreu]

Sorry, I'm very busy now. Please search this forum for messages related to your problems you'll shall find your answers, it's all there.

Regards,

Henrique Abreu