Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Include E-Mail Hyperlink within Data Table
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: Include E-Mail Hyperlink within Data Table
#30824
Include E-Mail Hyperlink within Data Table 11 Years, 10 Months ago Karma: 0
Hello -

Completely new to the forum having just bought the Ari Data Tables yesterday. Needed it to build a quick dynamic, searchable contact list in a Joomla 2.5.6 site. Went very smoothly. Thank you for good documentation.

What is required to in order to link e-mail addresses within the table? I am not a programmer and I do not have much experience with database work.

Here is the table in question on a test page of the client's site:
66.147.244.99/~bishopha/index.php/contact-administration-faculty-or-staff

Thank you!
Michelle
The administrator has disabled public write access.
 
#30831
Re:Include E-Mail Hyperlink within Data Table 11 Years, 10 Months ago Karma: 2
In the SQL Query text box of the module in question:

Code:

SELECT NAME, DEPARTMENT, EXTENSION, CONCAT('<a href="mailto:', Email, '">', Email, '</a>') AS E-MAIL
FROM Staff;




See this link when I asked the same question: http://www.ari-soft.com/ARI-Data-Tables/30467-Use-returned-data-in-link.html
Last Edit: 2012/08/23 03:31 By JugglingReferee.
The administrator has disabled public write access.
 
#30835
Re:Include E-Mail Hyperlink within Data Table 11 Years, 10 Months ago Karma: 748
Hello,

You can also use "Columns Settings -> Format" parameter. For this set "Columns Settings -> ID" parameter to E-MAIL value and "Columns Settings -> Format" parameter to the next value:

<a href="mailto:{$value}">{$value}</a>


Regards,
ARI Soft
The administrator has disabled public write access.
 
#30836
Re:Include E-Mail Hyperlink within Data Table 11 Years, 10 Months ago Karma: 2
admin wrote:
Hello,

You can also use "Columns Settings -> Format" parameter. For this set "Columns Settings -> ID" parameter to E-MAIL value and "Columns Settings -> Format" parameter to the next value:

<a href="mailto:{$value}">{$value}</a>


Regards,
ARI Soft


I just tried this method, by switching the module I had working using my method, and it works great!

Thanks!
The administrator has disabled public write access.
 
#30837
Re:Include E-Mail Hyperlink within Data Table 11 Years, 10 Months ago Karma: 748
If you have a problem with our solution, provide a link to a page where we can see it so we can investigate the problem.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#30839
Re:Include E-Mail Hyperlink within Data Table 11 Years, 10 Months ago Karma: 0
Thank you all for the help. I will definitely attempt and let you know if I get stuck.

An additional note: when I placed the module within an article using the data table plug in, the email field was correct and the links okay.

66.147.244.99/~bishopha/index.php/contact-faculty-staff

I will have to spend time when I am not on deadline with a frantic client to learn more.

Thanks for the support!
M.
The administrator has disabled public write access.
 
Go to topPage: 12