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


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

  • 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.


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 12 Years, 3 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 12 Years, 3 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 12 Years, 3 Months ago Karma: 760
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 12 Years, 3 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 12 Years, 3 Months ago Karma: 760
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 12 Years, 3 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