Hello!
I have a user that manages events. When an event is completed, she would like to automatically send an email with a QR code that will take the recipient to Cvent to complete a survey. My thought was to keep the QR code image in a Sheet Summary field and then link to it in the sheet via a column formula, then create an alert automation including that column. But the column with the link is just the name of the file (e.g. "QR code.png").
Is there any other way for me to accomplish this?
Quick background: I tried to do the survey in the sheet using an update request, but she didn't like the result. I also tried to think of a way to set up another sheet with a form for the survey, but couldn't think of a way to send it automatically with an identifier for the event included in the form, thus the Cvent route.
