I’m trying to create an automation that sends a slack message to a specific channel when a record is created/updated. THE ISSUE IS, I want it to send a message only if one of the fields equals something - conditioning. I can’t seem to see how to do so.
I see I can do that when I choose the option “when a record matches conditions” but I want to separate between creating and updating into two different channels and that I can’t do with this conditioning.
If I’m understanding you correctly, what you want is:
If record is created AND field value is equals to something, send Message 1
If record is updated AND field value is equals to something, send Message 2
If so, perhaps you could use the Last Modified Time field?
When a record is newly created, the Last Modified Time field will be blank, so you could have an automation that runs whenever a record is updated AND its field value is equals to something, and within it have a conditional checking whether the Last Modified Time is blank?
It didn’t work since the last modified field was not empty. so I tried the created field but the shortest amount of time available Is in the past week, which means I’ll get the notifications for all records created in the past week and not just the one that is currently being created
@Adam_TheTimeSavingCo is incorrect about the Last Modified Date, so his advice will not work. The Last Modified Date will only be blank if nothing has been typed into the record yet. Otherwise, it will always have a value.
However, I’m not sure I follow what you’re trying to accomplish, so I can’t guide you on a solution. Maybe create a video or post some screenshots.
I think I found a work around but now I’m facing another issue. I’m trying to create a dynamic channel name with one of the fields, but when I test it, AT claims the channel does not exists even though it does.
this is the channel name definition:
and this is the error I get:
but this channel does exist:
And it even appears in the list of channels when you try to choose a static one: