Pretty url with url text output

Questions & Answers
1

Hi there, new to Make and not really a developer.

I’m exporting data from a task in ClickUp to a Google Sheet and one of the things im exporting is a link.

I’ve tried to find a way to make www.google.com into a pretty link with text like this during the export.

image

There must be a simple way to do this that I’m missing.

Thanks in advance!
/Jacob

2

what is an example of UGLY URL that and a pretty URL?

Is it something like : Ugly → pretty.

www.google.com/1233/sfdsfs/42342 → www.google.com

Could you actually type it? It will help the understand the issue more.

3

Input:
www.google.com/123123213/15123123123/&5123123xxxxssjdh108y5123&2311231asdqdq?123213

How I want it to look (example):
image

So like this: LINK

4

Hey @TonkTonk,

You can use the formula =HYPERLINK("www.google.com/123123213/15123123123/&5123123xxxxssjdh108y5123&2311231asdqdq?123213", "OOH flödesschema")
to achieve this result.

Hope this was helpful!

3 Likes
5

Big thanks! Super simple!

6

It worked! Another related question:
How would I go about adding ALL attachments from the input?

This is what worked:
=HYPERLINK(“{{1.custom_fields.Reklamationsunderlag.url}}”, “{{1.custom_fields.Reklamationsunderlag.title}}”)

The attachments are part of an array and I want all array items or 1, 2, 3, 4. Is there any way this can be done simply? I’ve made a separate post about this.