Hi Joe, Sorry to disappoint you, but if you sort any column as 'ascending', the blank rows will always go on the top/first, then the other data comes after them.
Only if you switch it to 'descending', then the blank rows go last.
This is the default logic of the libraries on which our Plugin is based upon and we can't change it right now;
but you can make a development suggestion if you wish to see an option to change this in the future.
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
I see what you mean. For the time being, we don't have any custom way to achieve it, unfortunately.
I will keep checking with our developers over time - if we find any custom workaround to 'manipulate' that sorting and 'reverse it' for the blank rows - to have it show first when it is ascending, we will make sure to share it with you.
If you have coding skills and wish to try to make a custom solution now,
I have created a table linked to a Google sheet where I have numbers in columns signifying ranks. I have blank cells in some columns.
I want to allow users to sort by each column, but I want blank cells to go to the bottom of the column, not the top when sorted, especially ascending.
See attachment of the table in question.
Attached files: Screenshot 2024-09-20 125903.png
Hi Joe,
Sorry to disappoint you, but if you sort any column as 'ascending', the blank rows will always go on the top/first, then the other data comes after them.
Only if you switch it to 'descending', then the blank rows go last.
This is the default logic of the libraries on which our Plugin is based upon and we can't change it right now;
but you can make a development suggestion if you wish to see an option to change this in the future.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Yeah I'm aware that is the normal behavior. I was looking to see if there is a way to make this happen via conditional rules/css/js.
Thanks
Joe
Hi Joe,
I see what you mean. For the time being, we don't have any custom way to achieve it, unfortunately.
I will keep checking with our developers over time - if we find any custom workaround to 'manipulate' that sorting and 'reverse it' for the blank rows - to have it show first when it is ascending, we will make sure to share it with you.
If you have coding skills and wish to try to make a custom solution now,
you can check out our available hooks for Developers on this documentation and see if you can find any hook that might help.
We also added this new developer's handbook, which can allow users with coding skills to make custom add-ons.
Our developers will keep adding more custom hooks/examples there over time.
Please be advised that custom solutions with hooks are not included in our support.
You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.
( We do like to give examples for certain solutions, but for this use-case, we, unfortunately, don't have anything yet)
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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