Sep 25, 2023 10:00 PM - edited Sep 25, 2023 10:07 PM
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}, ">")
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
--------------------------------------------
when linking mulitple record
Sep 26, 2023 02:16 AM
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
Oct 11, 2023 07:41 PM - edited Oct 11, 2023 07:43 PM
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
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
4. trigger mentions via the memberID lookup field in Slack Notification Automation
Thanks for your help.