I have a spreadsheet where I track incoming email questions and outgoing responses. As questions come in, I have a script that appends a row (using .appendRow()
) with information in the first few cells. To make sending the responses easier, I would like to include the email address of the questioner as a hyperlink in one cell of the new row. I've tried using =HYPERLINK(...)
and get a syntax error.
2
1
Here's one way to make this work. It would be nice not to have the "mailto" show up, but this way does provide the correct functionality.
var string1 = new String ('mailto:');
var string2 = joeblow@gmail.com;
var address = string1.concat(string2);
sheet.appendRow(["", xxxx, yyyy, address]);
mailto:
links are allowed. What's the syntax you're using? Please edit your question. – ale Mar 12 '16 at 18:30