Pick values form different sheet

[Atit Shah]

Hi,

Can we pick the values from different google sheet and send and them in an email? By default the script picks and sends the values of the sheet, where the google forms responses are recorded. Can we change the source form to pick up the values from?

[Henrique Abreu]

Hi,

Yes, you can. FormEmailer works with any sheet.

But it's better if you have a good understanding of how formemailer works, just so you don't end up sending undesired emails.

Regards,

Henrique Abreu

On Mon, Jun 30, 2014 at 2:16 PM, Atit Shah via FormEmailer <formemailer+noreply-APn2wQd0n2Ps...@googlegroups.com> wrote:

Hi,

Can we pick the values from different google sheet and send and them in an email? By default the script picks and sends the values of the sheet, where the google forms responses are recorded. Can we change the source form to pick up the values from?

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

[Atit Shah]

Hi Henrique,

Thanks for the reply.

Picking up values from another sheet solved my problem but raised another one. So here's the scene, user fill ups the form and the responses are recorded, based on the responses entered there are some calculations done in the another sheet where the formulas are applied to the entire column.(I have installed the FormEmailer script on the sheet where the calculations are done). As soon as the responses are submitted there are n number of emails received..that is, for all the rows where the formulas are applied and the status is updated to Email Sent. Can you please help, how this can be tackled?

On Monday, June 30, 2014 11:12:36 PM UTC+5:30, Henrique Abreu wrote:

Hi,

Yes, you can. FormEmailer works with any sheet.

But it's better if you have a good understanding of how formemailer works, just so you don't end up sending undesired emails.

Regards,

Henrique Abreu

[Henrique Abreu]

Hi Atit,

I'm not sure I understood you properly, but I think you're having this issue:

Error sending email: Exception: Invalid email: #N/A
Auto email reply cannot run

Suddenly Sending Multiple Blank Emails

If after reading the threads above you still have doubts feel free to ask again here.

Kind regards,

Henrique Abreu

[Atit Shah]

Hi Henrique,

I am not able to install script in new versions of Google Spreadsheets. Can you please help me how this can be done?

--
You received this message because you are subscribed to a topic in the Google Groups "FormEmailer" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/formemailer/S6sUqUMIUDk/unsubscribe.
To unsubscribe from this group and all its topics, 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.

--

Regards,

Atit Shah

atit...@tudip.com | Skype: atitshah.tudip

www.tudip.blogspot.com | www.facebook.com/tudiptechnologies 

 +91 20 4674 0881 | +1 408 216 8162

  | 

[Henrique Abreu]

Hi Atit,

You have to install from source, take a look here:

https://sites.google.com/site/formemailer/group?place=msg%2Fformemailer%2FsBKjh5RQr2Y%2FvapEysKqeRIJ

Regards,

Henrique Abreu

[Atit Shah]

Thank you Henrique,

I am not able to send the mails and the script is not able to calculate values too, i think the quota has reached its limit. It worked absolutely fine for first 10 rows and then it stopped. The filed "Remaining Quota" in advanced settings is showing value 30 and it is un-editable. Can you please help me with this? 

[Henrique Abreu]

Please search the forum for "quota".

Henrique Abreu