How do you dynamically pull a list of all ticket-buyers for an event including those who may have registered on the day you are pulling the list?

I am shocked that this isn't a very basic functionality, but no one seems to be able to give me a straight answer. To explain:

We have an event this Sunday. We're allowing people to register right up to when the event begins. We would simply like to be able to send out an email right when the event starts to say, "Hey, here's the link to the event!" I would like to schedule this email in advance.

Has anyone found a basic way to create a dynamic list of registrants for an event with emails? Every time I pull anyone with the correct ticket history, but because ticket history only updates overnight I have to then look at anyone who had done an order that day to see if their order was for the right event, and then I have to basically manually put the lists together. Surely someone has a solution! Will I just have to end up writing some SQL here?

Parents
  • Thank you so much for posting this question! We're hoping to set up triggered emails in Wordfly for our performance reminders, and need to be able to capture that day's sales - especially for virtual events where folks are buying very last-minute. We don't have SQL skills on our team but this is all very helpful info! 

Reply
  • Thank you so much for posting this question! We're hoping to set up triggered emails in Wordfly for our performance reminders, and need to be able to capture that day's sales - especially for virtual events where folks are buying very last-minute. We don't have SQL skills on our team but this is all very helpful info! 

Children
No Data