Looking for suggestions! We are trying to build Workflows to assign an Action based on gift criteria, as well as the province as of the primary address for the constituent. We have 3 staff, who each cover a different region and the Action needs to be assigned based on the constituent's region.
We initially created Constituent Lists and used the filters for Latest Gift (including date of 'this calendar year') and Address. However, I am noticing a couple issues:
- if the same constituent gives two gifts on the same day and one meets the gift criteria, but the other doesn't, they don't appear on the List, since the gift that does meet the criteria is not considered the 'latest gift'
- if the same constituent gives a second gift that meets the criteria, since they are already on the list from their first gift, the Workflow does not run again.
Ideally the Workflow would run off of a Gift List, but my understanding is Workflows can only work with Constituent Lists.
To capture multiple gifts from the same constituent, we need to use a much shorter date range in the filter. However, the Constituent List filter only uses 'Gift Date' which for us is often different than the date the gift was added. So if I change the Constituent List gift date filter to 'Yesterday', it won't capture a gift that was added yesterday, but the gift date is actually a week ago.
Now that Lists can be based off Dynamic Queries, should I create a Query with the gift and address criteria, and use the gift date added as yesterday? Then, create a Constituent List based on the Query?