- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 19, 2025 08:42 AM - edited ‎Feb 19, 2025 08:43 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 19, 2025 08:49 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 19, 2025 09:14 AM
@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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 19, 2025 09:17 AM
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
