I am facing some issue with my Integromat format for timeline. Currently, I will need to map my timeline value. However, I have tried to follow the suggestion from other similar topics posted here and unable to get the value right.
There are error after I run the integromat. Its due to the wrong timeline format in value. I have ensure that the column id is matched with monday board.
Are you able to share what are the correct format for timeline to be inputted?
I will need to change the “to” date value with “from” date + “duration”(number column).
The easiest way to do this is to go back up to the board and select the specific board that you are going to be updating then go back to the columns select the timeline column… once all that is done you can then go back and change the board to mapping and put back the Id reference if you want.
Yes agree. However, I am planning to create dynamic board ID and Item ID based on the column changes in the monday. Therefore, I am using a webhook to get the data from monday (board id , item id) → connect them to integromat API (list board item) → Filter the changes → update the column.
The purpose is to use a single scenario for multiple boards in monday.
I just stuck in the timeline format if the field is not populated. Do you have some idea about what the timeline format might be?
That’s a great question! To me, it seems like you are running into this issue because you are using escape characters within the values you are sending.
Based on my understanding (@Michaela_Staffova, please feel free to correct me), Integromat does this on their end for monday.com modules. So, you can just send the From and To as a JSON object:
Oh, I can totally relate to that haha. It took me a while too, especially since different platforms or coding languages will require you to approach the formatting a different way.
Integromat also has a JSON module - I’ve seen users implement that in their scenarios in order to avoid dealing with formatting. Perhaps that could be a yet alternative way to tackle this.
Soooo there are a few things I’d like to mention here
It’s important to keep in mind that column ID does not change when you rename the column in the Monday UI. So even if your column ID is called “Planned Timeline”, the column ID still likely remains “timeline”.
@michael3 There are some slight errors in the JSON format. It is jut good old {“from”:“2021-11-04”,“to”:“2021-11-07”} - no need to escape anything
Also, the JSON is actually not needed If you select the column ID from the dropdown list and then turn on mapping, you should be able to enter your dates into the From and To field without having to deal with JSON while being able to map the column ID.
Because I’m slightly OCD and I like to give as much info as I can, I’m gonna leave the link to Integromat’s help doc about working with JSON in case anyone would like to check it out
It’s important to keep in mind that column ID does not change when you rename the column in the Monday UI. So even if your column ID is called “Planned Timeline”, the column ID still likely remains “timeline”.
Also, the JSON is actually not needed 
If you select the column ID from the dropdown list and then turn on mapping, you should be able to enter your dates into the From and To field without having to deal with JSON while being able to map the column ID.
)