Hey everyone!
With the Labour Day holidays coming up, we’d like to let you know about our upcoming working hours:
Thursday, May 1st: Our team will be off during Labour Day.
Friday, May 2nd: We'll also be off for an extended holiday break.
We’ll be back on Monday, May 5th, ready to respond to all messages received during this time.
In the meantime, if you need help, feel free to:
-
Use the support widget on the bottom right of our websites (Amelia and wpDataTables) — our AI-powered assistant is available 24/7 and can help with many common questions.
-
Visit our documentation, articles, or YouTube channels for quick answers and step-by-step guides.
https://www.youtube.com/@AmeliaWordPressBookingPlugin/videos
https://www.youtube.com/@wpDataTables/videos
Thank you for being so understanding, and we hope you enjoy the long weekend!
Hi team,
I would like to create a dynamique display. In the front end, when the user clicks on a raw, I would Like to display the column 2 of that raw in another text field. Have can I get that value using query?
Do you have an example?
Thank you in advance.
Gna
Hi Gna
Thank you for reaching out to us.
If I understand correctly you want an entry from the table as a hyperlink that would take the visitor to the specific post or page? That link would be dynamically generated by the content of the cell, right?
If that's true, you could use the CONCAT function, like this:
SELECT column1,column2, CONCAT('<a href="www.yourwebsite.com/page1/',yourTable.column3,'">',yourtable.column3,'</a>') AS HyperlinkFROM yourTable
This will create a hyperlink to www.yourwebsite.com/page1/value1 if there's "value1" entered as cell data in column3. On another row, it could be www.yourwebsite.com/page1/value2 if there's "value2" in the cell, and so on. So, this would be a hyperlink which could be shown in the modal, and it would take the user to the respective page.
I hope this helps, do let us know if you need any further assistance.
Thank you for you answers.
Actually what I want, is to display the column 3 content in a textarea when the user clicks on the row.
onRowclick -->> Display Column 3 content in TextArea.
Something like this
jQuery("#table_1").on('click', 't > a',function() { var row = $('#table_1 tr.selected').get(2); document.getElementById("myTestareaid").innerHTML = row; alert(link); });
HI team, found the solution:
jQuery(document).ready(function() {
jQuery("#table_1").on('click', 'tr', function() {
var entryrules = jQuery(this).closest("tr").find('td:eq(2)').text();
var exitrules = jQuery(this).closest("tr").find('td:eq(3)').text();
document.getElementById("txtEntryRules").innerHTML = entryrules;
document.getElementById("txtExitrulesId").innerHTML = exitrules;
//alert(exitrules);
});
});
Hi Gna
Firstly I want to apologize for the late reply I was out of the office.
I am glad to hear you found the solution once again I'm sorry I wasn't able to help in the meantime.
Do let us know if there is anything else we can assist you with.
Have a wonderful day!