Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Create hyperlinked list from view to be sent to Slack

Topic Labels: Automations Formulas
Solved
Jump to Solution
574 6
cancel
Showing results for 
Search instead for 
Did you mean: 
Marika_Vallier
6 - Interface Innovator
6 - Interface Innovator

Hi there!
I have been trying to get an automation to look at a view in Airtable and list up all the records with their hyperlink in a Slack message every Wednesday.

The outcome would be something like:´

Here's a few entries you can pick from:

  • SW-0001 (hyperlink to record)
  • SW-0002 (hyperlink to record)
  • SW-003 (hyperlink to record)

I have tried running a code but the list won't show (added images what I got for reference).

Does anyone have any idea how to solve this?

1 Solution

Accepted Solutions

Thanks!  The issue is with the selection of the variable; yours looks like this:

Screenshot 2024-09-08 at 1.00.02 PM.png
But it needs to look like this:
Screenshot 2024-09-08 at 1.01.03 PM.png

And to get that, you'll need to click the blue + icon at the top right and select it! 

Screenshot 2024-09-08 at 1.03.13 PM.png

See Solution in Thread

6 Replies 6
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hm could you include an image of the Slack automation setup? 

If it helps, the following code and automation setup works!

 

let recordList = ""

recordList += "<https://example.com|Link Text>\n<https://example.com|Link Text>\n"

output.set("test", recordList)

 

Screenshot 2024-09-07 at 10.37.48 AM.png

Screenshot 2024-09-07 at 10.37.32 AM.png

Link to base

Hi !
The automation setup is in the attachement called automation 1. Or do you mean something else?

I have replaced my code with yours and I get the same code run result than with mine so yours definitely looks less complex to reproduce in the future - thanks!

However, the message to Slack still doesn't showcase any actual list...

re: The automation setup is in the attachement called automation 1. Or do you mean something else?

Yeap, I'm curious how you've got the action set up and would like to see this bit!

Screenshot 2024-09-07 at 9.04.17 PM.png

I am not sure exactly which part you meant so please find a GIF attached. 🙂

Thanks!  The issue is with the selection of the variable; yours looks like this:

Screenshot 2024-09-08 at 1.00.02 PM.png
But it needs to look like this:
Screenshot 2024-09-08 at 1.01.03 PM.png

And to get that, you'll need to click the blue + icon at the top right and select it! 

Screenshot 2024-09-08 at 1.03.13 PM.png

Yay, thanks heaps Adam, that worked!