cell in grid with <a href=""></a>

Hello.

I have a grid with data: Id, Name, URL, Date

Need when visualize the result in grid, show only NAME, but need name by CLIKABLE and open new web page with information from URL.

In this moment, I have NAME and another columm with URL, in effect, URL is CLICKABLE, but need only NAME appear and by CLICKEABLE.

Anybody now if it’s possible???

Yes, create a text field and put the whole HTML into the database like this <a href=“https://amazon.com”>Amazon</a>

When it appears in the grid it will be a clickable link with only the Amazon part printed.

Or you generate the same thing by combining the two fields from the db.
$html = “<a href=’” . {url} . “’>” . {name} . “</a>”;
{newlink} = $html;

Put this in the events under “onRecord”. I tested the first method, the second may need better escaping using single quotes inside double quotes to get the same string as in the first example. .

Solutions works very well, really tank’s for both, thanks…