Something like this is only possible with SQL query-based tables. So, if this is a manual table, you can go to the Editing tab, enable it temporarily, to see the "MySQL table name for editing". Copy that name, and create a new SQL query-based table. Let's say the "MySQL table name for editing" is "wp_wpdatatable_1", so the query would be:
SELECT gpsnlatitude,
gpselongitude,
CONCAT('<a href="https://www.openstreetmap.org/?mlat=',wp_wpdatatable_1.gpsnlatitude,'&mlon=',wp_wpdatatable_1.gpselongitude,'&zoom=16" target="_blank">GPS Link</a>) AS Map
FROM wp_wpdatatable_1
Thanks for going through the testing. I'm glad to hear you were able to resolve this.
As for the report builder - please let me know if it works in the end, and if not, please provide me screenshots of the table, and the column settings (for columns which are included in Report Builder), and the template of the report, so I can take a look.
Good morning
I have a table with two GPS-coordinates columns (gpsnlatitude) resp. (gpselongitude).
(gpsnlatitude): "float" e.g.: 1.1234 with prefix "N " -> N 1.1234
(gpselongitude): "float" e.g.: 5.6789 with prefix "E " -> E 5.6789
Now I would like a third column (gpslink) to make a link to the openstreetmap.org page as follow:
https://www.openstreetmap.org/?mlat=1.1234&mlon=5.6789&zoom=16
How can I create the link as above from the two cells with the specific data, combined with the rest of the URL?
Thanks a lot and happy easter!
Hifi
Hello Hifi
Thank you for your purchase.
Something like this is only possible with SQL query-based tables. So, if this is a manual table, you can go to the Editing tab, enable it temporarily, to see the "MySQL table name for editing". Copy that name, and create a new SQL query-based table. Let's say the "MySQL table name for editing" is "wp_wpdatatable_1", so the query would be:
SELECT gpsnlatitude, gpselongitude, CONCAT('<a href="https://www.openstreetmap.org/?mlat=',wp_wpdatatable_1.gpsnlatitude,'&mlon=',wp_wpdatatable_1.gpselongitude,'&zoom=16" target="_blank">GPS Link</a>) AS Map FROM wp_wpdatatable_1I hope that helps.
Kind Regards,
Aleksandar Vuković
[email protected]
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
Hi Aleksandar
Thanks a lot for your fast and good help! I've attached the code once more:
SELECT gpsnlatitude, gpselongitude, CONCAT('<a href="https://www.openstreetmap.org/?mlat=',wp_wpdatatable_1.gpsnlatitude,'&mlon=',wp_wpdatatable_1.gpselongitude,'&zoom=16" target="_blank">GPS Link</a>') AS Map FROM wp_wpdatatable_1The small but important difference ist:
It took me some time, but for a beginner it was a nice lesson to learn a bit of the syntax ;-)
Kind regards,
Hifi
Hi again Hifi
Thanks for going through the testing. I'm glad to hear you were able to resolve this.
As for the report builder - please let me know if it works in the end, and if not, please provide me screenshots of the table, and the column settings (for columns which are included in Report Builder), and the template of the report, so I can take a look.
Kind Regards,
Aleksandar Vuković
[email protected]
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