Hi,

I can only assume I am missing something simple, but I have been working on this for a couple hours with no success.

I want the table results to have a column with brand names that you can click and they will take you to the website. I entered the data into the database using Fabrik, but when I display I get this:

{"label":"Brandname","link":"http:\/\/http:\/\/www.brandnamehere.com\/"}

If I click "recognize links" for the field under column settings it makes the link live, but shows the same as above.

If anyone can help I would be very appreciative. This forum has helped me a lot already.

Hello,

In what format data is stored in database? If data is stored in JSON format in one column, it is not possible to show link for this data.

Regards,
ARI Soft

Thanks for the fast reply!

I don't know what format the data is in or how to find out for sure. Under phpmyadmin it lists the column as "text".

I only have about 5 entries in my database now to test thing. So if there is a format I can use as a text entry to the database that will display as a name but be hyperlinked then that would be perfect for me and I can start doing that. Or any solution for that matter.

Thanks

Could you send SQL dump of table(s) which you use in "ARI Data Tables" module so we can investigate the issue?

Regards,
ARI Soft

Yes, I can do that, but my table is just a mess of random stuff and I think it would waste your time to make sense of it.

If you can tell me what I should input into the table column to then have a link displayed in my ARI data table I will be able to fix it from there and I am hoping that is easier for you too.

I tried using text and varchar field type fields and just entering the HTML into the field, but then it drops the link for some reason.

Example:

<a href="www.externallink.com/">Brandname </a>

If I put that into a varchar field, it just turns it into "Brandname".

Is there any way I can put a link into a text or varchar (or other field) that when it comes out in the ARI Table it does not display as the entire link (www.externallink.com/) etc?

It is possible to convert values from a column to HTML link, if it contains a link in the following formats:

www.domain.com/page.html

www.domain.com/page.html

and etc.

Regards,
ARI Soft