Display a calculated field as a URL?

[JohnM]

In Results Pages,  there is an option to render a field as a URL Link — but not if the field is a Calculated Field.

Is there a way to render a Calculated Field as a URL Link?

I tried including the anchor tags <a> and </a> in the calculation but that didn’t work. Caspio showed the anchor tags as part of the result.

 

[autonumber]

Hi! This forum post might be helpful for you.

[CoopperBackpack]

Hello @JohnM,

As far as I know in Release 34.0 this functionality was added. I mean rendering Calculated Field as HTML.

The site with my account has already been updated with Release 34.0 so I can use the formulas like this:

Example 1:

Output: 

 

Example 2:

 

Output: 

I'm assuming the site your account is on hasn't been updated yet.

Also, it can depend on the formula you use. 

Hope this helps.

[JohnM]

How do I know which release my site is running?

[PotatoMato]

Hi @JohnM, do you mean in which site your account is located? If yes, you can check it by going to account menu > account settings. You can also check here if your site is already updated with the current release version.

 

[Flowers4Algernon]

Hi @JohnM just wanted to add that you may read information regarding the latest release here: https://howto.caspio.com/release-notes/caspio-38-0/ 

[peterwoods]

A field called "Following Calculation" has been made.
Columns were then added to the work space.
Select "URL" from the "Actions" drop-down menu after clicking "Work Sheet" in the menu bar.
Choose the field that contains URL links.
The URL is now clickable from the Menu Bar.