Hello All,
We have recently implemented WordFly and would like to use it to send performance reminders to our subscribers. I'm wondering if there is a way to do this that would be totally automated. What we have in mind is to use a standard template that pull in fields from an output set that would populate the subscriber's name, the performance and the date of the performance. Since I am unable to use a standard output set that includes performance date and name without getting multiple rows for each subscriber, I'm wondering if anyone has figured out a way to do this in the back end - or if there's a way to limit the output in output builder to only the performance and perf_date that is associated with "run_date" + 3 days.
Hope this makes sense. I've not had a problem generating a list of Constituent Id's and an output set with names for 3 days out - but when I add the performance name, I start getting the multiple rows. I guess at this point, I'm thinking we can always use a different template for each performance so I don't have to pull the name and date; but it would be nice if the output set could populate 1 template that we could use for all performance reminders.
Your advice is greatly appreciated.
Hey Shellie!
This is on my 'to do' list as well! It has been brewing in the back of my head, so I guess this is my cue to collaborate!
I follow what you're saying and know a few things you can start with;
1: in the custom output set TR_Query_element row, there is a checkbox for returning a single row...
2: you can make nested queries within the select statement. Off the cuff, i'm not sure of the syntax, but something along the lines of LIMIT 0,1 or LIMIT 1 or the MSSQL equivilent, could limit the results.
Here is a rub i haven't worked out exactly; What if you have multiple performances on that date?
Just talking out loud here; perhaps your query could get join on perf_name where their ticket history has a performance = report run date? Is that too vauge? I'd be interested in seeing this through with you, if you want to post more of where you're at, or what you've done, i can try to get it to a more solid result.
Thanks for the push!
James