Hi all, I have a mission for myself and was hoping some of you may have thoughts on how to approach it. Right now we solicit RSVPs for activities (opening nights, first rehearsals, etc.) through a google form as well as via email (depending on what folks prefer). Our events person handles the emails and reviews the google form, and inputs the responses manually into the Activity section of that constituent's record. For responses that come in via email they respond to the email confirming the RSVP, but for the google form they'll send a mass one periodically to all of the folks who have RSVPed yes. As you can imagine, this can be a bit time-consuming, and as they have other jobs sometimes they don't confirm right away and folks get antsy.
I'd like to set up a triggered email to send daily to folks based on if the status of their activity had been set to "Accepted" the previous day, but I'm not sure the best way to do this. My first thought was maybe set the status to a new thing ("Confirmed"?) at first, then have a dynamic list pulling those folks which is used to send the email that morning, followed by a utility in the morning to update anyone with a status currently in "Confirmed" to "Accepted" (or maybe the other way around?). As of now that's my roundabout approach, but if anyone has other thoughts (or,even better, has something already set up!) I'd love to hear it!
Following