I have a contact list with a series of embedded date fields (DA01_Date, DA02_Date, DA03_Date… DA14_Date). I am trying to create workflows that send SMS survey invitations to contacts on their scheduled dates.
For example, I want to create a scheduled daily workflow that sends an SMS invitation to Survey1 to all contacts where DA01_Date = today’s date. (Note that this would not be triggered by a previous survey response. It’s just send survey X to a person on their assigned DA01_Date.)
I am surprised by how difficult this seems to be via workflows. In many cases as I’m trying to work this out, the issue that I run into is: How can I use my own directory data as the data source for a task?
What am I missing? How would you set this up?
