How to use formEmailer script with new Google Sheets

[Dan Longley]

Hi Henrique

I'm thinking of migrating to the new Google sheets to take advantage of two key features, however there doesn't seem to be a way to download and set up FormEmailer - they are not currently supporting the Apps marketplace. Is it possible to make FormEmailer work with the latest version of sheets?

Thanks

Dan

[John De Souza]

Dan & Henrique: same question here.

I did a manual installation, and all looks good... except that no action appears to be taking place.  No results are going into the "FormEmailer Status" field.

[John De Souza]

Actually... I got mine to work just fine.  I did not have the triggers properly configured.

[Henrique Abreu]

Yes, there's no Script Gallery in the new version of sheets, therefore the only way to install is manually. But it should work fine though, since it's the same API on Apps Script end, as John just said.

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/groups/opt_out.

[Michael Thompson]

John,

I'm having the same issue - how did you get the triggers reconfigured?  I'm having to manually process each time and I'm afraid to redo the trigger for fear that it will send news emails for all of the existing info in the sheet.

Thanks!

Michael

[John De Souza]

Michael, I could not get the new item trigger to work (probably my inexperience) so I configured the timer (see below).  I think that as long as the FormEmailer Status (first column) is set to "Email sent" it won't re-process.

[Michael Thompson]

With the new google sheets I can't find where to configure it to timer.  Can you point me in the right direction?

Thanks!

Michael

[John De Souza]

Tools --> Script Editor

Resources --> All Your Triggers

[Michael Thompson]

Thank you!

--
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/sBKjh5RQr2Y/unsubscribe.
To unsubscribe from this group and all its topics, send an email to formemailer...@googlegroups.com.

[Radoslaw Brzezowski]

Hi Henrique,

Any chances the FormEmailer will show up in the new add-ons?

Thanks,

Radek

On Tuesday, February 18, 2014 12:07:16 PM UTC+1, Henrique Abreu wrote:

Yes, there's no Script Gallery in the new version of sheets, therefore the only way to install is manually. But it should work fine though, since it's the same API on Apps Script end, as John just said.

Henrique Abreu

[Henrique Abreu]

Hi guys,

I have thought of it (turning FormEmailer into an add-on). But besides some technical issues, there's already a mail-merge add-on. Do you prefer FormEmailer over it?

I think the formulas and flexibility of some FormEmailer features to be the cause of most doubts among users. Something simpler satisfies 99% of use-cases and generates less frustration. What are your thoughts?

Kind regards,

Henrique Abreu

For more options, visit https://groups.google.com/d/optout.

[Arnaud]

As you notice in this Google Group, I love your script.

And what I find very pleasant is the fact that, because it's a script, you can do whatever you want with.
Google Add-ons are here to protect the source code... No debate here, but it's just... different.
And I you be glad to help you transforming your script into a Add-on.

Arnaud

[Dan Longley]

Hi Henrique

I've no experience of add-ons so difficult to comment, but it's the flexibility of FormEmailer that I like so much (including that time we tweaked the script to put in a time delay - worked a treat by the way).

Would an add-on allow me to use my own formulae? I've got the 'old' spreadsheet to import data, make mileage and timing calculations and tell me what time I need to depart, travel costs, etc.  I like some of the features of the 'new' Google spreadsheet, but I won't be moving across until I'm sure all the old features are available (unless Google shuts down the old version ).

What are the pros and cons?

Dan

[Henrique Abreu]

Well, it seems that a FormEmailer add-on would be welcomed :)

The main reason I won't do it now, is because addons are not allowed to set triggers. I imagine they will change this somewhat soon (this year), I'll publish FormEmailer as an addon then.

@Arnold Thanks a lot for your help. You're doing a great job here in the group!

Regards,

Henrique Abreu

[Jamie Rykse]

Yes, FormEmailer would definitely be welcomed! 

Crossing my fingers that Google will add triggers, that is a key feature of why I use your script instead of the others (that and the ability to send different templates to different recipients, ability to use formulas to get it to do what I want and many other of your features). I do not know how to write my own script but I do know how to follow directions which are available on the website and here in the group from other users. Thank you group members who have contributed help.

Thank you again for all your time and effort,

Jamie

P.S. Realizing I have not done so myself, on the FormEmailer website there is a donation link. Please thank Henrique for what he has done for us. Yes it is free but if you value the service you can always show your monetary appreciation. I just completed it using PayPal. The only catch is your are donating in Brazilian Reais. For me, $45 Brazilian Reais is about $20 US dollars.  Even a little bit would be nice. No, I do not have any connection to Henrique. I just like to show thanks to developers who provide a service that I rely on even if that service is free.

[Henrique Abreu]

That is really nice of you Jamie. Thanks a lot for your support, I really appreciate it.

Henrique Abreu

--

[Moshe Chaim Raices]

I have to agree.

the available solution in the add-on store has one innovation, the use of gmail as your editor.

That aside, clearly lack's the robust set of features in your script, and has many major bugs apparently.

I have been using your script quietly for 5 years in many different use cases as small as a spreadsheet that calculates my 10 line family phone bill and emails everyone their bill (I don't think multiple pages in a sheet is supported in the add on), and as big as camp registration (3+ seasons, registration, acceptance, rejection, and more) which would have worked for 10 seconds with this add-on.

DON'T UNDERESTIMATE YOURSELF!

[Robert Herron]

Please publish it as an Add-On.  Your script is awesome.  It's integral to something we do where I work.  Thank you for creating it, and thank you for making it an Add-On (if you do).

[Brian Gorsky]

I would love to see it as an add-on as well.

On Saturday, February 8, 2014 10:39:26 AM UTC-5, Dan Longley wrote:

~!~

[Lori B.]

Yes, please!  An Add-On!
Lori

[Norm Cox]

I couldn't agree with everyone more. Your script is fantastic. I have made it work just fine in the new forms but would like to see it as an add-on. I think you script is easier for the 99%ers - the body of the notification is already created for them, if they want to remove a few fields or add a little text it is easy. Other add-ons have you start with a blank email/document/spreadsheet and have you put the body and fields together. 

With it turning to winter in Brasil I hope you find some downtime to turn this into an add-on :-) 

On Tuesday, March 18, 2014 6:26:29 AM UTC-6, Henrique Abreu wrote:

Hi guys,

I have thought of it (turning FormEmailer into an add-on). But besides some technical issues, there's already a mail-merge add-on. Do you prefer FormEmailer over it?

I think the formulas and flexibility of some FormEmailer features to be the cause of most doubts among users. Something simpler satisfies 99% of use-cases and generates less frustration. What are your thoughts?

Kind regards,

Henrique Abreu

[Mary M.]

Hi everyone,

I'm not sure if this is the right group to post this question, but I am trying to figure out how to make a conditional trigger, where it emails one address the contents of the form if a particular response is chosen from a dropdown in Question #1, and someone else the contents of the form if a different response is chosen. Is this possible? 

Thanks for any help!

Mary

[Norm Cox]

Hi Mary, yes it is possible with a combination between an array formula and an IF formula.

In the image below I had the cells in column B look into column A and IF the answer was '12' column B was populated with 'jimj...@gmail.com'. I Use the array to automatically fill in all cells upon form submit (without array you would have to 'pull down' all formulas as when a form is submitted a new line is created and no formulas are continued). More on that here.

Here is the formula used in B2

=arrayformula(if(len(A2:A)=0,iferror(1/0),if(A2:A=12, "jimj...@gmail.com")))

Your formula could get very lengthy if you have a lot of options to question 1.

You would then just use the email as a placeholder in your FromEmailer set up.

I am guessing someone could make this a lot cleaner but this is the best I can do.

Good luck,

Norm 

[Henrique Abreu]

Actually, with FormEmailer you do not need to use ArrayFormula (at least not for this), FormEmailer can copy your formulas for you when a new form is submitted.

Which, first, allows you to write simpler formulas, and second, gives your more control and options over your formulas, like replacing them with their values after they're evaluated. This is good to make your spreadsheet lighter/faster (with less formulas to process, specially useful with costly formulas and lots of rows) and also good for formulas that depend on dates, which can change as time goes and you'll lose what was really sent (replacing with a value makes it a snapshot of the values really used when that line was processed).

See how to use FormEmailer formulas location parameter here: https://sites.google.com/site/formemailer/advanced

Regards,

Henrique Abreu

--

[Justin Weisbrod]

How do you do a manual installation? 

On my spreadsheet of Form Responses I went to Tools, Script Editor, New/Blank. Then I pasted the FormEmailer code, renamed it to FormEmailer.gs. Clicked Save. 

Then I copied the FormEmailer worksheet to my new workbook, now what?! How do I "install" it?

[Justin Weisbrod]

Update: changed the code on FormEmailer Sheet/tab/worksheet from: 

{"s":{"fSheet": "Sheet1" 

to

: "fSheet": "Form Responses 1" 

Now Column A on my Form Responses 1 sheet got populated from FormEmailer script but with "Field does not exist:" repeatedly. The previous FormEmailer tab (which used to go next to the Help button) had a Settings button, where you would configure the email recipients, subject, and body. How do I configure my settings? Is it manually in field B3? See pic.

[Henrique Abreu]

You should not change any FormEmailer's code. I recommend that you uninstall the version you currently have and follow these steps:

https://sites.google.com/site/formemailer/getstarted#TOC-Install-from-website-source:

There's also uninstall instructions there, please take a look. Remember to remove the FormEmailer sheet as well and the status column if you have added it manually.

Henrique Abreu

--

[Erandi Disanayake]

Hi Henrique,

I'm working with FormEmailer. Any chances the FormEmailer will show up in the new add-ons or in any other option?

Because it's very important to me to continue my projects.

Thanks..

Erandi

[Henrique Abreu]

Hi Erandi,

Yes, it will. When it's possible to do so.

Regards,

Henrique Abreu

[Kim Briske]

I agree, FormEmailer has been a wonderful tool. I look forward to seeing it as an Add-on...hopefully sometime soon!! Thank you so much for creating it!

On Saturday, June 14, 2014 11:43:46 AM UTC-5, Henrique Abreu wrote:

Hi Erandi,

Yes, it will. When it's possible to do so.

Regards,

Henrique Abreu

[Audrey Galvin]

We used FormEmailer for our District's summer school registration. When parents wanted a change in their child's schedule, we edited and it was so easy to send a new confirmation manually. I found out how to write a script for confirmations but not how to manually send one with all the formatting, etc. I loved FormEmailer! Plus there was no 100 limit. We had nearly 600 students for summer school. No way we could use MailMerger for that! Oh wow, I don't know what we'll do next year!

[Kristina Mattis]

I really miss FormEmailer, regardless of other mail-merge add-ons already in existence. The ease of FormEmailer is very attractive. Please consider publishing it as an add-on (hopefully before the new school year starts...in a few short weeks).

Thank you!

On Tuesday, March 18, 2014 5:26:29 AM UTC-7, Henrique Abreu wrote:

Hi guys,

I have thought of it (turning FormEmailer into an add-on). But besides some technical issues, there's already a mail-merge add-on. Do you prefer FormEmailer over it?

I think the formulas and flexibility of some FormEmailer features to be the cause of most doubts among users. Something simpler satisfies 99% of use-cases and generates less frustration. What are your thoughts?

Kind regards,

Henrique Abreu

[G. Massicotte]

Yes, FormEmailer would definitely be welcomed! 

I have received numerous request from staff members wondering how they could do this.

Greatly appreciated.

gm

[Phillip Boshoff]

Hi Henrique

Has there been any development with regards to making form-emailer accessible in the new google sheets?

thanks

On Saturday, June 14, 2014 6:43:46 PM UTC+2, Henrique Abreu wrote:

Hi Erandi,

Yes, it will. When it's possible to do so.

Regards,

Henrique Abreu

[Henrique Abreu]

Hi Philip,

No, not yet.

Regards,

Henrique Abreu

[Phillip Boshoff]

Thank you for the swift reply! I saw there was an option for a manual install - that seems to work fantastically. Took me two minutes to set up.

Thanks!

	phillip boshoff pretoria  SHOFAR CHRISTIAN CHURCH T +27(0)12 362 1363 F +27(0)12 362 4736 E PHILLIP...@SHOFARONLINE.ORG FB WWW.FACEBOOK.COM/PHILLIPBOSHOFF TW WWW.TWITTER.COM/PHILLIPBOSHOFF W WWW.SHOFARONLINE.ORG

 

--
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/sBKjh5RQr2Y/unsubscribe.
To unsubscribe from this group and all its topics, send an email to formemailer...@googlegroups.com.

[Ann Gregson]

Can you tell me how to do a manual installation?

[Henrique Abreu]

Take a look here: https://sites.google.com/site/formemailer/group?place=msg%2Fformemailer%2FC8fOTovr10E%2F9bqyMhIGrQ4J

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.

[Sara DeVoogd]

John, 

Could you please say more about how you did the manual installation of the script?

Thank you,

[latiff mohamed]

Hi Henrique;

Thanks for the hard work. I use the formemailer for Form+ cause I need the upload file features. Everything is fine, the trigger works perfectly but the email only send out to my gmail account. I add the bcc to other email. And what shows in my gmail is only a link to my spreadsheet. And the bcc to my email doesn't work. No email from the form submitted to my other email. And also no email send to the person who fill up the form & submit. I do 4 test, fill up the form & hit the submit button but still nothing shows in both the form & to the person who submit the form. Not sure what went wrong but i follow the installation step by step. I use the formemailer before via the google doc form, everything runs okay. The output shows as per what it should be. But now it shows nothing but a link to the spreadsheet. You can see my screenshot i attached here. 

Thank you in advance. Hope that you can help me with the problem..

[Henrique Abreu]

Hi Latiff,

Those emails were not sent by FormEmailer, as it clearly shows on the sender, it's a Form+ notification email.

Back to FormEmailer, what's shown on the status column? How have you set up the trigger, i.e. you used on-form-submit or time-driven? (please send a screenshot of your trigger setup).

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.

[Meg Boland]

Please do!  I use your script on very important work spreadsheets and the other mail merge one is not at all functional for me.  I LOVE your script!

Meg

On Tuesday, March 18, 2014 6:26:29 AM UTC-6, Henrique Abreu wrote:

Hi guys,

I have thought of it (turning FormEmailer into an add-on). But besides some technical issues, there's already a mail-merge add-on. Do you prefer FormEmailer over it?

I think the formulas and flexibility of some FormEmailer features to be the cause of most doubts among users. Something simpler satisfies 99% of use-cases and generates less frustration. What are your thoughts?

Kind regards,

Henrique Abreu

On Tue, Mar 18, 2014 at 8:32 AM, Radoslaw Brzezowski via FormEmailer <formemailer+noreply-APn2wQf1AlQs5QSZwrr3K4Gi7Jor6NLpnMO5O_Uh-hvd@googlegroups.com> wrote:

Hi Henrique,

Any chances the FormEmailer will show up in the new add-ons?

Thanks,

Radek

On Tuesday, February 18, 2014 12:07:16 PM UTC+1, Henrique Abreu wrote:

Yes, there's no Script Gallery in the new version of sheets, therefore the only way to install is manually. But it should work fine though, since it's the same API on Apps Script end, as John just said.

Henrique Abreu

On Tue, Feb 18, 2014 at 3:26 AM, John De Souza via FormEmailer <formemailer+noreply-APn2wQcR_NY-qxzQJj6e-RGCDoQISt3d-o3Adgad2...@googlegroups.com> wrote:

Actually... I got mine to work just fine.  I did not have the triggers properly configured.

On Monday, February 17, 2014 10:46:40 PM UTC-5, John De Souza wrote:

Dan & Henrique: same question here.

I did a manual installation, and all looks good... except that no action appears to be taking place.  No results are going into the "FormEmailer Status" field.

On Saturday, February 8, 2014 10:39:26 AM UTC-5, Dan Longley wrote:

Hi Henrique

I'm thinking of migrating to the new Google sheets to take advantage of two key features, however there doesn't seem to be a way to download and set up FormEmailer - they are not currently supporting the Apps marketplace. Is it possible to make FormEmailer work with the latest version of sheets?

Thanks

Dan

--
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/groups/opt_out.

[Meg Boland]

How do I get to the settings now in the new Google sheets?  I have the script loaded but it doesn't pop up "Form Emailer" option in my menu bar. :(

[Henrique Abreu]

Open the script editor (Tools > Script Editor) and run the onOpen function. It should prompt an authorization and then show the menu.

It should open automatically later.

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.

[Oryan]

go to this link

https://www.youtube.com/watch?v=-6DfZ_lCKjY&feature=youtu.be

On Thursday, October 30, 2014 3:23:11 PM UTC-4, Henrique Abreu wrote:

Open the script editor (Tools > Script Editor) and run the onOpen function. It should prompt an authorization and then show the menu.

It should open automatically later.

Henrique Abreu