Send email only when condition is met.

[alert ping]

Hello all!

I searched through all the 256 topics but couldn't find an answer for this one.

I have a form setup that, once completed, will fill column B to O with data. I have a different script that will the retrieve a link to edit the response and put it in column P. The problem is that FormEmailer is a lot faster than my crappy script. So what happens is that FormEmailer will send the email before the link has been retrieved, which means that the link will not be send with the email. I've tried to make my script trigger more frequently and FormEmailer less frequently so it has time to catch up. But that doesn't work.

My question is: Is it possible to make FormEmailer only send the email once a column has been filled with data? Or in my case: Is it possible to make FormEmailer only send an email once column P has been filled.

Any help would be greatly appreciated!

P.S.: Thanks for the great script. It has been a tremendous help in my company. I'm donating once I get my next paycheck :)

[Henrique Abreu]

It's probably easier to move your function to inside FormEmailer's code and run it from the doIt function, so it's guaranteed that it'll finish.

I'm guessing that if you coded this yourself, you can probably find your way in FormEmailer's code and even have it pass to your function the values on the row that is being processed.

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.

[alert ping]

Thank you for your reply.

Unfortunately I don't have any experience coding. I've simply copied the other code from the Google Script forms.

Is there no other way of achieving this without changing FormEmailers code?

[Henrique Abreu]

I don't think so, no.

Maybe this approach is simpler for you, take a look:

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

Henrique Abreu

[alert ping]

The method you posted didn't work for me unfortunately.

I found a workaround. I managed to modify my other script into a standalone script that still does the same but is a lot faster. It works for now, let's hope it stays that way.

Thanks for your help Henrique!

On Thursday, April 24, 2014 7:30:19 PM UTC+2, Henrique Abreu wrote:

I don't think so, no.

Maybe this approach is simpler for you, take a look:

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

Henrique Abreu