Hi
Background
Sheet A: This sheet is generated from "Google Form". The column A:Q is my google form question.
Sheet B: I create a new sheet and column A is Formemailer column. The cell B1 is =ArrayFormula('Sheet A'!A:Q). So, this Sheet B(column B:R) can has same answer as Sheet A once some one submit the google form.
In sheet B, the column S~AF, I used the formula to calculate the option which is filled by user in google form. Of course in my formemailer setting(Email body) uses those columns.
Relationship
In sheet A, it only has same response "ROW" as google form response. If there is only 3 response so far, it only has 1~3 rows. The row will be added once submit new form.
In sheet B, column A:R will be updated if any change in sheet A.
But for column "S:AF", I need to fill in the formula first. for example, I fill in =If(C5="","",d5*e5/2) and copy paste to row 10.
I simplified above status.
There are three response in google form.
In sheet A: Only Row 1~Row 4. (First row is name label) Column A:Q.
In sheet B:
Column A is for formemailer status. Column B:R is same as Column A:Q in sheet A. Only row 1~4 has data including row 1(label name).
Column S:AF are my formula and it is filled until row 10.
Please be noted the
A2:R4: Same as sheet A.
A4:R10 is blank.
R2:AF10: formula. Will be calculated once any data in A:Q.
Issue
Now I submit a new form. (The fourth response)
In sheet A: Generate row 4 by google system including the answer. A5:Q5.
In sheet B:
B5:R5 is same as A5:Q5 in sheet A.
B6:R10 is blank.
S5:AF5 is updated automatically according data.
S6:AF10: Still has formula only.
The email is sent for the fourth response (row 5: S5:AF5) and the answer is correct.
The problem is row 6 to row 10 (S6:AF10) are sent by formemailer. Of course the content including blank and formula.
I tried only fill in formula in row 5-row 7 and blank in row 8~10. The email will be sent from row 5 to row 7.
Could you help me? I can send the file to your email if you need.
Thank you.
Hi Background Sheet A: This sheet is generated from "Google Form". The column A:Q is my google form question. Sheet B: I create a new sheet and column A is Formemailer column. The cell B1 is =ArrayFormula('Sheet A'!A:Q). So, this Sheet B(column B:R) can has same answer as Sheet A once some one submit the google form. In sheet B, the column S~AF, I used the formula to calculate the option which is filled by user in google form. Of course in my formemailer setting(Email body) uses those columns.
Relationship In sheet A, it only has same response "ROW" as google form response. If there is only 3 response so far, it only has 1~3 rows. The row will be added once submit new form. In sheet B, column A:R will be updated if any change in sheet A. But for column "S:AF", I need to fill in the formula first. for example, I fill in =If(C5="","",d5*e5/2) and copy paste to row 10.
I simplified above status. There are three response in google form. In sheet A: Only Row 1~Row 4. (First row is name label) Column A:Q. In sheet B:
Please be noted the A2:R4: Same as sheet A. A4:R10 is blank. R2:AF10: formula. Will be calculated once any data in A:Q.
Issue Now I submit a new form. (The fourth response) In sheet A: Generate row 4 by google system including the answer. A5:Q5. In sheet B:
The email is sent for the fourth response (row 5: S5:AF5) and the answer is correct. The problem is row 6 to row 10 (S6:AF10) are sent by formemailer. Of course the content including blank and formula. I tried only fill in formula in row 5-row 7 and blank in row 8~10. The email will be sent from row 5 to row 7.
Could you help me? I can send the file to your email if you need. Thank you.