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?