Task management is a common use case that we love using the Slack pack in Coda for. Before you begin, install the Slack pack to your Coda doc. Visit our Using the Slack pack article for instructions on how to install.

Send a Slack message to multiple people

Imagine you have a table that contains a list of tasks. In this table, you have the following columns for each task listed: Task, Assigned, and Due date. We can achieve this with a button press using the Slack pack and formulas in Coda.

image.png

To send a Slack message to all members mentioned in the Assigned column (assuming this is a People column format), we’ll take advantage of the email addresses associated with every Coda profile to send notifications directly to each assignees’ DMs.

To begin, add a new button to the table. Then, click the f button to bypass the formula builder and add your own custom formula. If you opt to copy & paste the formula below, be sure to update inputs like the User's private Slack account authentication key and any column references that don't exactly match up.

thisRow.Assigned.Email

.FormulaMap(

RunActions(

Slack::PostMessage(

[User's private Slack account],

"Your assigned task, " + thisRow.Task + ", is due on " + thisRow.[Due date] +

".",

CurrentValue

)

)

)

This will send a direct message to each Assignee stating “Your assigned task, ____, is due on _____.”

image.png

If you want your notifications to be more complex than this without sacrificing readability, try using the Format() formula to create your message template instead of the Concatenate() or + symbol formula used in our example.

Related Articles

  1. Using the Slack pack

  2. How do I use FormulaMap()?

  3. People column format

Did this answer your question?