Skip to main content

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. 

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

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. 

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

Reply


Terms & Conditions