Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Weekly tally counter for task being completed

Topic Labels: Automations
1117 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Leveling_Up
4 - Data Explorer
4 - Data Explorer

I am trying to set up an automation that keeps track of how many videos my editors are completing a week. I currently have it set up to send me a slack message every time they set the stage to be “completed” but I would like it to say something along the lines of “Mark has completed 2 of 10 videos this week” and then have that number both increase throughout the week and reset at the beginning of the week

2 Replies 2

I think it might be better to solve this without automations, and instead using a Count field with filter criteria. In my below example, I have an active player base, and each player submits a score randomly throughout the week.

image

Below, I’ve added a “Count (Score Entry)” (renamed to: Games Played This Week) column with an active filter on the records Creation date.

image

Interested in your thoughts on this solution, let me know if this solves your workflow.

Leveling_Up
4 - Data Explorer
4 - Data Explorer

I think to incorporate that I may have to make a whole additional table. Our current set up looks like this
Example
When they are finished with the video, they set the stage from “editing” to “complete” and then that record gets filtered out of the grid view to clear up space. Your solution would require a new table to be made that would be more permanent and would require a bit of manual work to maintain. I’d like to keep it as automated as possible but it is definitely a good solution if I can find nothing else! Thank you!