Slacks Notification - Change Request

Rairai31 · ‎09-19-2023

Hi All,

I am very new to Slacks Integration Notification, I have this requirement:

Notify when a Change has been submitted
Notify how many changes are scheduled for the day

I have created this for the notification when a change is submitted.

Could you please help me how can I achieve to display how many changes are scheduled for the day? Is that possible? Thank you very much. I really appreciate your feedback. Thank you.

Elijah Aromola · ‎09-19-2023

You will need to query the change_request table using a "Look up records" action with a query of start date today. This action in Flow Designer gives you a "count" pill which is the number of returned records. With this pill you should be able to add a message such as "INSERT PILL HERE Changes scheduled today".

View solution in original post

Elijah Aromola · ‎09-19-2023

You will need to query the change_request table using a "Look up records" action with a query of start date today. This action in Flow Designer gives you a "count" pill which is the number of returned records. With this pill you should be able to add a message such as "INSERT PILL HERE Changes scheduled today".