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!
How do I remove the summation sign and the equals sign from a calculated field with the shortcode? I want to integrate the actual number calculated as a dynamic tag and cant.
Also, it seems that use the SUM syntax in writing my own MYSQL queries?
following up here
Hello Brett
No need to follow up, as soon as we get to your tickets we will respond. There is an increased amount of tickets coming in, so our response times are longer than usual. Also, we don't work on weekends, and our working hours are Mon - Fri from 10:00 - 17:00.
I believe you'd like to add some text to it as well, right? Something like "The table has 600361 rows"?
If this is true, then let me show you how to do it with some CSS.
My table has 21 rows, so if I use the [wpdatatable_sum table_id=1 col_id=1] shortcode with the text, it comes up like this:
"The table has" is stored like this:
So, you have to right click on the <p> go to Copy/Copy Selector, which comes back with this:
Then, we move to "∑ =". You'll see this:
Right-click on "wdt-column-sum" Copy/Copy Selector. I got this:
Also, you will have to use the wdt-column-sum to get it to display inline.
After that, move to "rows":
So, the final output would be:
And this is how it looks on front-end:
You should be able to use the whole CSS I pasted here, no need to search for selectors. I just wanted to break it down, so you understand what's happening.
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