Very much hoping you amazing people can help me out with something that’s stumping me
I have a small ranking system on the side of my forum to show the ‘most helpful’ users (a repeating group with the appropriate constraints):
This is set by a workflow that increases the “upvote” count by 1 each time it is clicked:
This also adds the user who clicked “helpful” to a list of users attached to the Reply:
The part I’m struggling with is somehow filtering this ranking section (the repeating group) to only show the total count of upvotes from the last rolling 30 days.
My first thought was there would be a constraint I could use that would say something like “field: upvote, modified in last 30 days”, or a step in the workflow that adds the upvote +1 that would “remove result of Step 1 after 30 days have passed” or something similar, but I can’t seem to find out how to do this.
Can anyone help me figure out a way to call only the last 30 days’ worth of upvotes to show in this repeating group?
Thanks in advance!