Reminder Automation send Slack message

Vanessa_dozgn3

Hello there,

I would like to setup a reminder automation that sends a Slack message to a person when a certain date is reached.

I have looked in a few similar articles but their solutions did not work out for me.

Maybe you can point me in the right direction.

So far I have:

• A custom field named 'Remind me' which is a date picker field.
• The 'scheduled' part.
• The 'Send a Slack message' with the Webhook

What I would need:

1. The Automation should run every morning (for testing it is every 5 minutes so that I do not have to wait until the next day to see if it works).

2. I have no idea what to write in the JQL, I took this out of another article in the community but it doesn't work.

3. It would need to send a Slack message which contains the certain Issue that the reminder is set too. Here I would also need help with the JQL

 

Thank you so much already!

All the best,

Vanessa

Daniel Eads

Hi @Vanessa ,

This is quite close! There are just a couple changes to make this rule work as you intend.

1. In your scheduled trigger, you can remove the JQL filter. We will do a JQL search in a new action.
2. Add a Lookup issues action above the Send Slack message action. The JQL you have will go in this action:

   "Remind me" >= startofday() AND "Remind me" <= endofday()

That's all! Your newly modified rule will have that new action here:

 

The reason we'd use a "lookup issues" action rather than the JQL filter in the trigger is to populate a list of issues. You want to step through the list of issues in your Slack message, so we have to generate that list first. It's a slight difference from how it would work if we just searched those issues from the trigger - the end result is that you'll get one Slack message with a list of issues, rather than multiple Slack messages.

Cheers,
Daniel