I rank users by number of “posts” created in a month. How would I send users an email announcing the winner at the end of each month?
Seems easy? But what if there’s two winners?
Here’s what I’ve done so far:
Data type of “user” with 12 fields for total posts in each month of the year. (I use a WF to count posts as it happens)
- total posts created in Jan
- total posts created in Feb
- total posts created in Mar
Data type of “monthly winners” with fields for
- user’s name
- total number of posts created
- month name
Now I want to create a recurring backend WF that will create a new “monthly winner” - so I can create an email that say’s “the January winner is Fred with a total of 15 posts created”.
This seems easy, I could just create a WF with a
do a search for user, sorted by total posts created in jan: first item which will give me the 1st user in the list sorted by Jan - aka the winner. But what if there’s two winners?
I thought I could run workflow on a list and search for users until item#. Here’s how a tie is handled on a Repeating Group. But I can’t figure out how to run this same expression on a list through a Database search.