I have a customer list with a hidden Email co...

(Dana Gude) #1

I have a customer list with a hidden Email column.

I then have an action button that when clicked, sets the hidden Email column of the selected customer to “Print” which then triggers a workflow to email me a summary of the client.

I’d like to be able to each time it generates an email to create a new line in a second sheet, populate an increasing count column with the next available number, save the client unique ID along with the date&time. This way I can see through the app when it was generated, for whom, and other needed details.

Is there a way to do this?

(Aleksi Alkio) #2

Do you need to see an email log or would it be enough if you would see just the last email date/time?

(Dana Gude) #3

I just want to save in the spreadsheet the Email log number, the Customer ID, and Date Email is sent

(Bellave Jayaram) #4

@Dana_Gude writing to other sheets is not yet supported but if your need is urgent and you are comfortable with scripting, you could use this technique - https://productforums.google.com/forum/#!topic/docs/7CaJ_nYfLnM