Record (Copy) Column Summary at point in time

Platform discussions Special workflows & use cases
1

I’d like to record a column summary (a number) at a point in time - weekly. Any ideas? Much appreciated.

2

Hi Jeff,

Just to confirm, would you essentially like to filter the column summary to a certain point in time?

3

Every Thursday at 6pm, I’d like to automatically copy the column summary of a number column to a different column for a specific item. Basically, I’m trying to capture that number in order to see week to week changes to the column summary.

4

Hi Jeff,

Thank you for your question.

I can confirm that your requirement can be solved by the app Advanced Automations for Monday.com which will allow you to create automations as code to help solve business requirements.

Using Advanced automations you would be able to set a Scheduled Trigger which would run your script on the schedule you define.

Your script would then used the Monday.com API to fetch the value from the column you want to copy the value from and to then copy this value to this field.

We have lots of example template scripts inside the app that will show you how to do this and the templates for setting item values and rolling values will show how to get and set values to help you write the script you require to solve your requirements.

You can see more detailed information on how the app works in its documentation page here.

I hope this information helps.

Regards,
Kristian