+1Is 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?
+31Use 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)
+1Use 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
+31Thank 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} & ")"
+1Ah, you need to reference the formula fields, so something like:
"[" & {namecopy} & "](" & {Website} & ")"
Thanks!
Almost there. I used your formula and got this.
+31Thanks!
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)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.