I have a large database and I need to move some of the rows around (I need to move a row near the top down a few rows, and then a row from the bottom of the front page towards the top). How do I do this? I know how to edit a row, but how can I change the order the data is displayed in?
Can you please tell me which table type is this table from the url ( Excel, MySQL, Manual ).
It is not possible to achieve something like this with the plugin build in features, but there are some workarounds or some code customization if the table is manually created.
The first option will be to change the wdt_ID column from the database and in that way put the rows in the desired place.
Other option require some code customization where you can make ranked column from example to 1-100. That column will be hidden in the front end and you can edit the data in that column in the back end.
For example you have table with 10 entries so the ranked column have values from 1 to 10. If you want the row which have rank 8 to put it in the second place you just change the entry for that column from 8 to 2 and for 2 to 8( or any other number) from the backend.
You can find some similar example on this link if you want to develop something on your own.
We offer paid customization services where you can hire one of our developers to implement this feature for you. Our price is 50$/hour and customization like this require 2 hours of work.
If you are interested let us now so we can send you a quote for this service.
Thank you so much for your suggestions! I was able to make the changes I needed to (phew, otherwise I would have had to find a different table creator, and I was really happy with wpDataTables for the most part!). Is there any feature request page where I could suggest you build that ability into the plugin in the future?
I have a large database and I need to move some of the rows around (I need to move a row near the top down a few rows, and then a row from the bottom of the front page towards the top). How do I do this? I know how to edit a row, but how can I change the order the data is displayed in?
(For whatever reason, it won't let me list my URL in the "Related URL" field, so here it is instead: http://www.paddedtushstats.com/retailer-database/)
Hi Kenner82,
Thank you for your purchase.
Can you please tell me which table type is this table from the url ( Excel, MySQL, Manual ).
It is not possible to achieve something like this with the plugin build in features, but there are some workarounds or some code customization if the table is manually created.
Best regards.
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
It appears that I did manually create this one! So what are my options?
Hi Kenner82,
The first option will be to change the wdt_ID column from the database and in that way put the rows in the desired place.
Other option require some code customization where you can make ranked column from example to 1-100. That column will be hidden in the front end and you can edit the data in that column in the back end.
For example you have table with 10 entries so the ranked column have values from 1 to 10.
If you want the row which have rank 8 to put it in the second place you just change the entry for that column from 8 to 2 and for 2 to 8( or any other number) from the backend.
You can find some similar example on this link if you want to develop something on your own.
We offer paid customization services where you can hire one of our developers to implement this feature for you. Our price is 50$/hour and customization like this require 2 hours of work.
If you are interested let us now so we can send you a quote for this service.
Best regards.
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
Thank you so much for your suggestions! I was able to make the changes I needed to (phew, otherwise I would have had to find a different table creator, and I was really happy with wpDataTables for the most part!). Is there any feature request page where I could suggest you build that ability into the plugin in the future?
Hi Kenner82,
Good job on finding the solution on your own, well done.
You can write your feature request here, I will definitely add this to our TODO list so maybe we can implement it for future releases.
We have some plan for the next couple of months to release some add ons, so stay tuned.
Best regards.
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