How to Notify Team Members in Slack When a Task is Overdue Using Airtable Automations

In this video, you'll learn how to notify team members in Slack when a task is overdue using Airtable automations, lookup fields, and concatenate formulas.

Posted on:
January 28, 2022

In this video, you'll learn how to notify team members in Slack when a task is overdue using Airtable automations, lookup fields, and concatenate formulas.

IF({Due Date}=BLANK(), '👌' , IF({Complete?}=TRUE(), '🚀',    IF(IS_AFTER({Due Date}, TODAY()), '🕙', '❗️')))

CONCATENATE("<@", {Who Assigned? Slack ID}, ">")

CONCATENATE("<@", {Task Owner Slack ID}, ">")

Find a user's Slack ID in seconds: https://www.workast.com/help/articles/61000165203/

Want receive the best workflow automation insights? Subscribe now!

The best and brightest business minds come to us for insights on building systems of scale.

Thanks for joining our newsletter.
Oops! Something went wrong.