I’m using Knack to manage memberships of a club.
I have an object - Membership Statistics - that is manually updated every month with a snapshot of counts of different types of memberships (Individual, Family, Honorary etc). This is done via a page where a query creates a table by a filter on each membership type, and displays the count for each table. At the bottom of the page is a form where we manually copy these counts into each field on an edit form and on pressing Update it adds a new row to the stats record.
It struck me that this should be automatable. Can anyone point me in the direction of what I would need to do to create a task that on running (once per month), will get a count of records returned by a set of queries and create a new row in the statistics records?