Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Formula to return text and URL

Topic Labels: Formulas
144 3
cancel
Showing results for 
Search instead for 
Did you mean: 
LP2
4 - Data Explorer
4 - Data Explorer

I have a table of books with the following columns

  • Book Title
  • year published
  • Amazon Link
  • Bookshop.org Link

I want to create a field that returns Book Title (Year Published) Amazon Bookshop, where the "Amazon" is linked abd "Bookshop.org" is linked.

Is it possible to use a formula to return text with links? I tried creating columns for buttons, but when I include the button in the formula, the output is just the URL. 

For each author, I want to roll up a list of their books with the corresponding links. 

3 Replies 3
Mike_AutomaticN
10 - Mercury
10 - Mercury

Hey @LP2!

The formula field itself cannot achieve that, as it does not support rich text (e.g. hyperlinks).
However, if you construct a formula that by using markdown would handle the format of the corresponding rich text, then you could use an automation to get such output from the formula and paste it on a Long Text field. 

Mike, Consultant @ Automatic Nation

@Mike_AutomaticN thanks. I was really hoping to do this without an automation. I wonder if I could just roll up a few fields into one. 

Mike_AutomaticN
10 - Mercury
10 - Mercury

Yes @LP2!

You can use rollups for sure. Check this article for more information on rollups

However, rollups will not help you with the rich text! You’ll need to push the output from the rollup into a Long Text Field via automation unfortunately