Forums

How to make a column clickable to an external url?

tshirley 22 Jun, 2017
Hi,

I have a simple CC5 list which includes a column containing a website URL which differs for each row. I want to make this column clickable - not to an edit function but to navigate to the URL in the column.

I have tried placing the field in the Links section but it does not highlight the field or allow it to link. Example

cl.website:http://{cl.website}

No doubt I am missing something simple here but can someone explain?

Cheers

Tim
GreyHead 22 Jun, 2017
Hi Tim,

What is a typical value in cl.website? Can you post a link to the listing?

Bob
tshirley 22 Jun, 2017
Try

http://www.admin.glidingaustralia.org/index.php?option=com_chronoconnectivity5&cont=lists&act=index&ccname=ClubListfromLocator

It is a public list.

Cheers

Tim
GreyHead 22 Jun, 2017
Hi Tim,

I'm not sure if it goes in Links or in HTML but please try
cl.website:<a href='http://{cl.website}' >{cl.website}</a>

Bob
tshirley 22 Jun, 2017
Hi Bob,

No change when placed in either location I'm afraid. I can see what it is trying, and I agree with the idea. But no luck so far.

Thanks for trying.

Tim
Max_admin 22 Jun, 2017
Hi Tim,

In the linkable column you can try:
cl.website

If that does not work then I suggest that you use v6 for this connection only, it was built to make tasks like this easier.

Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
tshirley 23 Jun, 2017
Hi Max,

Good suggestion to use CC6 and I have installed and built my basic listing. It is different but obviously very powerful.

But now I need a hint to get the column to display the data as a clickable link. I can see that Element-Link should be able to do it, but the syntax for this isn't clear to me yet. Can you help please?

Thanks

Tim
Max_admin 23 Jun, 2017
Hi Tim,

You need to create a link view then call it in your table under the "Columns views", it will be something like this:
column:{view:link_view_name}

In your link view you need to reference the table column view:
{var:table_view_name.row.Model.field_name}

Please check the tutorial in the FAQs section as it will clarify some basics about v6.

Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
tshirley 24 Jun, 2017
Hi,

Thank you. Yes I had found the FAQ and this helped a lot.

I created a Iink and set the column view. In the link the Content field is set to {var:table2.row.cl.Website} and the URL to {var:table2.row.cl.Website}

When I tried your suggestion the view created a link in the column (the column content is a url that varies from row to row), but when I clicked the link it delivered this:

http://www.mysite/administrator/index.php?option=com_chronoconnectivity6&cont=manager&conn=clublistfromlocator&event=view

This is my website back end and it displays a blank view of the connection. But I I was expecting it to pick up the URL to navigate to from the data in the field cl.Website.

Cheers

Tim
Max_admin 24 Jun, 2017
Hi Tim,

But did you change the link "url" too ?

Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
tshirley 24 Jun, 2017
Hi Max,

The Column view is cl.Website:{view:websitelink}

and websitelink has the URL set to {var:table2.row.cl.Website}.

I am not sure what else can be set up. I can see what is supposed to happen, I just don't get why it does not use the url in the link.

Cheers

Tim
Max_admin 25 Jun, 2017
Hi Tim,

Please post a screenshot for the Link view setup.

And what is the value in the "Website" field ?

Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
tshirley 25 Jun, 2017
Hi Max,

I have attached a file with a screenshot of the Link view and also the Preview of the running connection.

Value in the website field sould be a valid url or blank. This is test data and not every listed url is valid. However when clicking any of the links, I get the same result which is

http://www.admin.glidingaustralia.org/administrator/index.php?option=com_chronoconnectivity6&cont=manager&conn=clublistfromlocator&event=view


I can provide an admin login if it helps.

Thanks

Tim
Max_admin 27 Jun, 2017
Hi Tim,

A patch is needed to fix this, please send me a message using the "Contact us" page and include the link to the topic.

Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.