Help

Send message to Slack that mentioning multiple users

Topic Labels: Automations Formulas
783 2
cancel
Showing results for 
Search instead for 
Did you mean: 
이선호
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello everyone.

I'm a Korean user, but there are still few AirTable users in Korea, so it's hard to find a solution, so I wrote to the community for the first time.

I'm trying to use automation to send messages to Slack that mentions multiple users.

I've tried several ways to do this, but while I know how to mention a single user, I haven't found a way to mention multiple users yet.

I've tried the following formula and automation, but it didn't work.

1. @Mention using a Slack username

 

 

 

<@first.last>

 

 

 

2. @Mention using Slack user's ID

 

 

 

<@memberID>

 

 

 

3. Dynamic @mentioning

 

 

 

CONCATENATE("<@", {Slack member id lookup}, ">")

 

 

 

_1-1695703451763.png

All of these methods worked when I linked only one record, but when I linked multiple records, they didn't work correctly.

ex.)
when linking sigle record

_2-1695703778403.png

--------------------------------------------

when linking mulitple record

_3-1695703871555.png

Does anyone know how to solve this problem? 😭

 

 

 

2 Replies 2

Hi @이선호,

You should be able to make multiple mentions in a Slack message in Airtable automations by adding the member IDs in the correct format. For example if the Slack Member ID is UO3UGP6K91B, then the Slack message to make two mentions would need to have this format:
<@UO3UGP6K91B><@UO3UGP6K91B>

I hope this helps!

Website: https://alessiomonino.com
Calendly: https://alessiomonino.com/contact
Email: alessio.monino@gmail.com

이선호
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks to your advice, I have solved the problem.

I solved the problem in the following way

1. record each user's memberID in the form "<@{memberID}>" per record in the user information table

_0-1697078271723.png  

_4-1697078595300.png

 

2. in the other table, add a CC field link to the user information table

3. add the user's memberID as a lookup field

_1-1697078357305.png

4. trigger mentions via the memberID lookup field in Slack Notification Automation

_2-1697078424992.png

 

Thanks for your help.