Skip to main content

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?

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)


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


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} & ")"

 


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

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

 


Thanks!

Almost there. I used your formula and got this.

 

 


Thanks!

Almost there. I used your formula and got this.

 

 


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)


Reply