A unique number for the row to the email

28 views
Skip to first unread message

Fox

unread,
Mar 26, 2017, 4:23:50 PM3/26/17
to FormEmailer
Hi,

I have created form, which goes to the spreadsheet. Then is automaticly generated an email by the FormEmailer.

My question is...

I have fields, which go to the generated email.

For example:

<b>Last name: </b>#Surname/Lastname#<br>
<b>First/Given name: </b>#First/Given Name(s)#<br>
<b>Organisation: </b>#Organisation#<br>
<b>Job position: </b>#Job position#<br>
<b>Postal address: </b>#Postal address#<br>
<b>E-mail: </b>#e-mail#<br>


So, Is there any option, how can I put an unique number of the row to this email too.

Something like this...

<b>Variable symbol: </b>#ROW ()#<br>

Or, is there any option, how to automaticly generate cell of the row, where volume could be an unique number..? Which I can add as a paramter to the generated amail..

Thank you for kind help.

Fox

Henrique Abreu

unread,
Mar 27, 2017, 2:14:01 PM3/27/17
to FormEmailer on behalf of Fox
Hi Fox,

Yes, this is possible. All you have to do is create a new column, setup your formula on row 2, open FormEmailer settings > advanced > formulas location
And set the formula address: sheet name and column there
Use this new column in your email template in any way you like.

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

Reply all
Reply to author
Forward
0 new messages