Monday.com - Date Columns

[EQuestions]

What is your goal?

Hi all,

Novice here, very new to Make.

I am trying to run a daily automation that updates a date column in a Monday.com board to ‘today’ for all items.

In essence, the aim of this is to display (in the Monday.com Gantt view) how long an item (being a job in an accounting firm) has been assigned to a certain person.

Monday already allows for a date to be assigned when a person is assigned. I have named this column ‘Date Assigned’.

I have also added a ‘today’ column. I want this date to be updated daily.

When the ‘today’ date is updated daily, this will update a timeline which will show the duration from when an item has been assigned to someone to the current day.

I am currently using a Monday.com agent for this task, however am worried this will burn through Monday’s ai credits quickly.

What is the problem?

Monday.com does not appear to have a built-in “set to today automatically” feature via the API alone. I am being directed to run a script to do something like this.

I am therefore turning to Make.com to automate this task at a more cost-effective solution.

What have you tried so far?

I have managed to set a schedule update a single item in a board, which I have to map individually.

This however is not feasible for every item, and will have to be updated when new items are added.

I have also tried updating the timeline directly, however I do not believe the API allows for this.

Screenshots: scenario setup, module configuration, errors

[Stoyan_Vatov]

Hey there,

What do you mean it’s not feasible for every item? Have the first module list all items in the board then the second module update the date to today.

[EQuestions]

My issue is that once the first module has listed all items, I don’t understand how the second module updates all items in the board, as it seems I have to individually select a target item to update it as below

[Stoyan_Vatov]

You toggle the map button next to item id and map the item id coming from the first module.

[EQuestions]

I have tried that - however I am still prompted to map a specific item. If I do not, I am met with errors

Below are the mappable fields - none of which seem to work If i want to update this for every item

If i try the below, I am met with the following error:

[Stoyan_Vatov]

It’s called ID. Then the error shows you didn’t set the column that needs to be changed.