Hi,
I have created an event data sheet that has six columns (event name, date, attendee and then three other informational columns). The first three columns (name, date, attendee) will be filled in by my marketing department. I need to create an automation that emails the attendee and asks them to fill out a questionnaire (form) providing the information for the remaining three questions of that event row. I want the event information (1st three columns) to be auto-filled in the form. I need the email automation to go out every week until all information has been gathered. I do not want the attendee to have access to the data sheet. I also do not want the attendee to fill out a new form every time the automation runs. I think this is an update request, but I am not sure if it can be done without giving the attendees sheet access. This is why I am trying to go the form route.
Any direction that can be provided would be greatly appreciated.
Thanks in advance.