I’m new to Integromat. I’m using the “Watch Board” function as I want to update one field in a row based on a value from another field in the row if the row has changed.
I have it running every hour, but Integromat seems to think the data is changing in every row on every scan. I’m not sure if it’s an integromat or monday issue. Is Monday updating data behind the scenes on rows that would make Integromat think there is some change in a board even though nobody is logged in or using it?
Because of that my field update is updating every row (which in this case, because it’s merely a copy is no big deal), however that’s 14 ‘updates’ which counts as 14 “actions” in integromat which will blow through my monthly allocation.
What is the Integromat monday.com module that you’re using? Is it “Watch Board’s Items”? Or something else?
If it’s the “Watch Board’s Items” module, this module will be trigger each time an item is created or updated, regardless of which of the item’s columns was updated.
In this case, it might make more sense to utilize the “Webhooks” Integromat module instead. This will give you more customizability to create a more specific webhook that will only trigger once a specific column has been changed. Is this what you’re asking about?
The method I would probably use is the one Helen suggested. If you are looking to update a column every time another changes this is probably the best solution. Otherwise, maybe you could give us more details on the specifics of your use case so we can give you an answer that is more suited to your situation.
I do have situations where I save a copy of a column’s value and then process on a scheduled basis (usually nightly) those items that have had changes. It all depends on the details of what you are wanting to accomplish.
Yes I was thinking about the webhooks option which is more of a real time integration. The problem is I can’t find a single blog, post here, or video on how to use webhooks specifically with Integromat & Monday.com.
Do you guys know any links? If you are consultants, there is definitely some good google search positioning awaiting you on this topic.
Also, while I have your attention, whats the syntax in the filter to say only where a field has no data? Best I could figure out was where length >0. I would think there is something like ‘not null’
So I tried your steps and got this to work, awesome!
So when I put a value in an email field, it copies that value to a text field (due to an automation bug I need to work around)
When I add a value to the source field and when I change it, it works.
However… When I hit the x to delete the value of the field (it’s an email source field), it triggers the webhook but does not remove the contents of the destination field.
When I look at the webhook details after the ‘run’ In Operations>Output>Bundle 1>Event>Value> there is no data at all. When there is an email, it has ‘email’, ‘text’ and ‘changed at’ on the field. But when it’s deleted, its completely blank. It’s not like it says ‘email:’ so that it can copy a blank email. The api just isnt’ sending any metadata on the field so integromat doesn’t know what to do with it.
Thoughts on how to clear one field if the contents of another are deleted?
For most column types you can just write an empty string using the “Update Column Values of a Specific Item” module. However, I have found that for some column types (like phone), I have to call the change_simple_column_value API directly. Here is an example:
So the only way I could get it working was to use a router that sends when there is data in the source to one update and if there is no data (length of field=0) another way. The problem is if I try and assign ‘null’ to the destination text field it throws an error. If use “” (usually means no text in other software) it literally puts two quotes in the field. The only way to make the field show as blank is to push a single space character in which really isn’t blank. Any specific syntax to make sure a destination field is simply no text?
No, I was trying to take an email column and copy it as text to a text column. (Because of a bug in one of Monday’s native automations that are supposed to pick up an email address but only show’s text fields in the pick list)
