Several Problems [autorun, formula, deleted rows, ...]

[Mölln]

Hello and thank you for the script :)

Unfortunately I got some problems with the implementation.

I want to run a registration for a sports event.

Through a survey I ask for some personal Data and for the different swimming distances.

This information are used for a confirmation-mail.

Some formulas are used to determine the price.

For example: =(IF(ISNUMBER(SEARCH("500m Seeschwimmen";I5;1));10;0)) [About 11 Formulas]

First I tested everything manually - and it worked fine.

Then I deleted the answers (the rows 2-5) and copied in the formulas in row 2 again.

But when I submit another answer via the survey again - the data is printed above the row with the formulas and that causes #ERRORS#.

Even a whole new buildup results in #ERROR# when I try to use autorun.

When I run the first line manually and after that I use the autorun I got no problems - but that cant be the solution for new projects :(

Autorun Settings tested so far:

• timeDriven - from table - on form submit
  
• timeDriven - timedriven - minutly
  

What am I doing wrong?
Where is the mistake?

Thanks in advance

Shefe

[Henrique Abreu]

Hi Shefe,

Unfortunately row 2 has to be there with "sample" data. It does not have to be a real submission (i.e. show up in your Form statistics), but it has to be there on the spreadsheet. FormEmailer takes the formulas on row 2 as an example to set on new rows.

I guess you'd just have to ignore this row on your analysis. You could even create another sheet filtering it out, to make things easier for you. e.g.

=ARRAYFORMULA('Formularantworten 1'!A3:Y)

About the trigger, I recommend using the second option: timedriven - 5 minutes

Regards,

Henrique G. 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+unsubscribe@googlegroups.com.
To post to this group, send email to forme...@googlegroups.com.
Visit this group at https://groups.google.com/group/formemailer.
For more options, visit https://groups.google.com/d/optout.

[Mölln]

Thank you for the fast reply!

So - I need to fill the 2nd Row of the Sheet with Dummy-Data?
I thought it would be enough to Fill it with the Formula - here two Screenshots.

First picture all the formulas for calculation. When I submit an answer via the survey I get #ERROR# in the new second row and the third row with the formulas in it.

Second Picture I fill the Sheet with Dummy-Information and the calculations begin - after that I have to process the Script manual once and after that it works quite fine.

Is that right? 
I find this a little strange :)

Best regards

Shefe

Am Mittwoch, 22. März 2017 14:13:57 UTC+1 schrieb Henrique Abreu:

Hi Shefe,

Unfortunately row 2 has to be there with "sample" data. It does not have to be a real submission (i.e. show up in your Form statistics), but it has to be there on the spreadsheet. FormEmailer takes the formulas on row 2 as an example to set on new rows.

I guess you'd just have to ignore this row on your analysis. You could even create another sheet filtering it out, to make things easier for you. e.g.

=ARRAYFORMULA('Formularantworten 1'!A3:Y)

About the trigger, I recommend using the second option: timedriven - 5 minutes

Regards,

Henrique G. Abreu

On Wed, Mar 22, 2017 at 9:22 AM, Mölln via FormEmailer <formemailer+APn2wQfQfGNAcKcuE-WrFRl9M6rr3SvyHlkSzoBpJ4cJz3M3nf...@googlegroups.com> wrote:

Hello and thank you for the script :)

Unfortunately I got some problems with the implementation.

I want to run a registration for a sports event.

Through a survey I ask for some personal Data and for the different swimming distances.

This information are used for a confirmation-mail.

Some formulas are used to determine the price.

For example: =(IF(ISNUMBER(SEARCH("500m Seeschwimmen";I5;1));10;0)) [About 11 Formulas]

First I tested everything manually - and it worked fine.

Then I deleted the answers (the rows 2-5) and copied in the formulas in row 2 again.

But when I submit another answer via the survey again - the data is printed above the row with the formulas and that causes #ERRORS#.

Even a whole new buildup results in #ERROR# when I try to use autorun.

When I run the first line manually and after that I use the autorun I got no problems - but that cant be the solution for new projects :(

Autorun Settings tested so far:

• timeDriven - from table - on form submit
  
• timeDriven - timedriven - minutly
  

What am I doing wrong?
Where is the mistake?

Thanks in advance

Shefe

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

[Henrique Abreu]

This is the way Google Forms work, not the script.

Google Form will look at the lines of the associated sheet to determine what's the last line. If you don't have anything on its columns, it'll assume that the sheet is blank (i.e. only the header is present).

After determining the last line, Google Forms will create a line on that position (shifting down every existing line below it), and put the answers there.

Being a little redundant to try to be more clear, Google Forms ALWAYS creates new lines, it does not use the existing lines on the sheet.

Where it'll create the new line depends on where the "last" filled line is. That's why you need a dummy value somewhere there.

And again, this is the way Google Forms work and has nothing to do with the FormEmailer script.

Regards,

Henrique G. Abreu

On Wed, Mar 22, 2017 at 11:54 AM, Mölln via FormEmailer <formemailer+APn2wQfQfGNAcKcuE-Wr...@googlegroups.com> wrote:

Thank you for the fast reply!

So - I need to fill the 2nd Row of the Sheet with Dummy-Data?
I thought it would be enough to Fill it with the Formula - here two Screenshots.

First picture all the formulas for calculation. When I submit an answer via the survey I get #ERROR# in the new second row and the third row with the formulas in it.

Second Picture I fill the Sheet with Dummy-Information and the calculations begin - after that I have to process the Script manual once and after that it works quite fine.

Is that right? 
I find this a little strange :)

Best regards

Shefe

Am Mittwoch, 22. März 2017 14:13:57 UTC+1 schrieb Henrique Abreu:

Hi Shefe,

Unfortunately row 2 has to be there with "sample" data. It does not have to be a real submission (i.e. show up in your Form statistics), but it has to be there on the spreadsheet. FormEmailer takes the formulas on row 2 as an example to set on new rows.

I guess you'd just have to ignore this row on your analysis. You could even create another sheet filtering it out, to make things easier for you. e.g.

=ARRAYFORMULA('Formularantworten 1'!A3:Y)

About the trigger, I recommend using the second option: timedriven - 5 minutes

Regards,

Henrique G. Abreu

To unsubscribe from this group and stop receiving emails from it, send an email to formemailer+unsubscribe@googlegroups.com.

[Mölln]

Alright - thank you again!

I didn't found anything about this on this sites - but it will work then :)

When I worked a little more with this script ill try to translate it to german.

Best regards

Shefe

[Mölln]

I need your help again o:)
I have already some filled rows in the spreadsheet, but new submissions are put on top of the spreadsheet again.
I copie f.e. the latest two responses and do everything manually now below the first responses and delete the row 2 and 3 but new responses take the same place :(

Figurative:

1. 

dummy

2. 

Response 1

dummy

=>change to:

dummy
Response1 (proceed manually)

3.

Response 2
Response 3
dummy
Response 1

Whats wrong?