Help

How to create name + hyperlink in a cell with bulk list?

1551 5
cancel
Showing results for 
Search instead for 
Did you mean: 
jameshere
4 - Data Explorer
4 - Data Explorer

Is it possible to create one collumn that contains name with a hyperlink combined?

I know how to do it manually. Is there a way how to do it automatic?

I can easily do this in bulk on google sheets. But when trying to paste the data from sheets to airtable it just shows the name without the hyperlink.

How do I do this automatic?

5 Replies 5

Use a formula field to format your hyperlinks into `[LINK TEXT](URL)`, for example, `[Google](www.google.com)`, and then use an automation to paste that value into a rich text field (a long text field with rich text enabled)

Thank you for your answer.

I've two collumns.

"namecopy" and "Website"

If I understood you correctly I did what you said. And it won't merge.

"Namehttps://i.ibb.co/nR9r00G/image.png

Ah, you need to reference the formula fields, so something like:

"[" & {namecopy} & "](" & {Website} & ")"

 

Thanks!

Almost there. I used your formula and got this.

 

jameshere_0-1676571757128.png

 

You'll need to use an automation to paste that value of `[Google](www.google.com)` into a rich text field (a long text field with rich text enabled)