Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Slack message triggered by formula field?

Topic Labels: Automations
Solved
Jump to Solution
165 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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”?

1 Solution

Accepted Solutions

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

See Solution in Thread

2 Replies 2

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.