Skip to main content
Answer

Slack message triggered by formula field?

  • August 2, 2022
  • 2 replies
  • 16 views

Forum|alt.badge.img+10

I just connected a base to slack and I’d like to automatically message a specific employee when a customer’s credit card expires. I have a field with expiration date, another field with a formula “IF({Expiration Date}<TODAY(),“Expired”,“Valid”)”. Is there a way I can trigger a slack message when this field is “Expired”?

Would I use “updates to watched record” to configure slack message? If so, how do I make my formula field a “watched record”?

Best answer by Vivid-Squid

Hi @Dustin_Good
You can use the When a Record Matches a Condition trigger. The condition should be when the formula field is Expired.
Then add an action to Send Message in Slack

2 replies

Forum|alt.badge.img+16
  • Inspiring
  • Answer
  • August 2, 2022

Hi @Dustin_Good
You can use the When a Record Matches a Condition trigger. The condition should be when the formula field is Expired.
Then add an action to Send Message in Slack


Forum|alt.badge.img+10
  • Author
  • Known Participant
  • August 2, 2022

Hi @Dustin_Good
You can use the When a Record Matches a Condition trigger. The condition should be when the formula field is Expired.
Then add an action to Send Message in Slack


Thank you @Vivid-Squid. This did exactly what I needed. Interesting that from the other view it was not as clear as this automation.