I looked at the documentation to convert emails into clickable 'mailto:' links using the || method. However I have about 55 emails listed from an sql database so I can't exactly go into the sql database and edit those email fields. Is there any way to make this happen for all emails?
I tried adding "||Send an email" in the suffix of the column but it just displayed "name@email.com||Send an email"
Hi,
I looked at the documentation to convert emails into clickable 'mailto:' links using the || method. However I have about 55 emails listed from an sql database so I can't exactly go into the sql database and edit those email fields. Is there any way to make this happen for all emails?
I tried adding "||Send an email" in the suffix of the column but it just displayed "name@email.com||Send an email"
Thank you for your time.
Hello CreativeLeif
Thank you for your purchase.
Since they are coming from the database, you can concatenate the column through the query, like:
SELECT column1, CONCAT(`table1.emailColumn`,"||Send an email") AS email FROM table1Then it will be applied to all emails in emailColumn.
I hope that helps.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables