Unfortunately, there's no easy way of doing this (like drag and drop).
If it is a manual table, it has a hidden wdt_ID column, which is an auto-increment column. That means it is automatically assigning a new row number every time you enter a new row. That column is not editable, and it's not advisable to change the ID column for editing:
You could go into the database, find the table's database name (usually wp_wpdatatable_#, where # is the number of the table in the database), and modify the wdt_ID column and rearrange the rows from within the database.
To see the exact number, open your table in wpDataTables, go to "Editing" tab, and enable editing. You'll see something like this:
So, when you open that table in PHPMyAdmin, you'll see it like this:
Select the rows you wish to swap (check-boxes on the left), and select Edit below the entries:
Then, in the modal that opens up simply enter new row numbers (they can't be existing, so if you wish to swap 2 and 4, you need to modify both of them):
After you save that, the table will show row 2 in place of row 4, and vice-versa.
Unfortunately, this limitation renders the plugin useless to me.
I bought your software to be a replacement for Tablepress, which you can move rows around with a very simple drag and drop process.
And because also this is a very easy function to do with Excel, I assumed this feature would be replicated in your software.
I'm extremely surprised that your plugin is limited in this very basic way.
Therefore, I cannot use your software, so I would request a refund.
Also, I have sent another email because the first time I purchased, the checkout process did not complete, so I entered my details again..... which resulted in me paying twice for your software.
So, please could you refund me for both of these purchases.
Sorry to hear you don't want to use the plugin after purchase.
Although, completely understandable.
You need to log into http://store.tms-plugins.com/ with the credentials you received in your e-mail when you purchased the plugin, then navigate to Purchases/wpDataTables, and if you're still within 15 days from purchase you will see the "Request Refund" button.
You should see both purchases there, so you will be able to refund them through the store.
Hmmm, not sure why this would not be a default function. I too just want to add an entry in the middle and can only seem to add to the bottom, and then no way to reorder. Seems like a very common and straight-forward needed function.
I understand where you're coming from, but wpDataTables is built around the DataTables jQuery plugin, so it needs to follow its rules.
At the moment, there' no way to insert a row at a random position. Similarly to adding a row to the database - you can't just add one in a certain position without affecting surrounding rows.
This is something we will work on in the future, but at the moment, it's not possible.
I have a need for this as well. I have a set of chronological rows with dates from 1946 to 2023.
Unfortunately my data for 1988 was entered later so it is at the bottom after 2023 and i need it moved up to after 1987;
Is there no SQL command that will move all the rows down by renumbering the wdt_ID columns, creating however many spaces I need to move the 1988 data up?
I'm afraid that the workaround provided in one of my earlier responses is still the only way to do this.
Our developers are working on reordering rows, and I hope it will be available in Q1 2024, but I can't make any promises, as the plugin would need to change the IDs of the rows based on the change, so it's not an easy task.
A work around that has worked for me is to use the "Excel Like" view to copy the table contents into Excel, reorder and arrange there, then copy-paste back into WPData Tables. Would be nice to have this functionality in a future revision though as it is a basic feature of most table based platforms.
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 just want to do something very simple, but have been searching for 20 minutes.
All I want to do is reorder some rows - ie move a row from line 3 to line 1.
Can't find any intuitive way to do this.
Please help
Hello James.
Thank you for your purchase.
Unfortunately, there's no easy way of doing this (like drag and drop).
If it is a manual table, it has a hidden wdt_ID column, which is an auto-increment column. That means it is automatically assigning a new row number every time you enter a new row. That column is not editable, and it's not advisable to change the ID column for editing:
You could go into the database, find the table's database name (usually wp_wpdatatable_#, where # is the number of the table in the database), and modify the wdt_ID column and rearrange the rows from within the database.
To see the exact number, open your table in wpDataTables, go to "Editing" tab, and enable editing. You'll see something like this:
So, when you open that table in PHPMyAdmin, you'll see it like this:
Select the rows you wish to swap (check-boxes on the left), and select Edit below the entries:
Then, in the modal that opens up simply enter new row numbers (they can't be existing, so if you wish to swap 2 and 4, you need to modify both of them):
After you save that, the table will show row 2 in place of row 4, and vice-versa.
Best regards.
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,
Thanks for the reply.
Unfortunately, this limitation renders the plugin useless to me.
I bought your software to be a replacement for Tablepress, which you can move rows around with a very simple drag and drop process.
And because also this is a very easy function to do with Excel, I assumed this feature would be replicated in your software.
I'm extremely surprised that your plugin is limited in this very basic way.
Therefore, I cannot use your software, so I would request a refund.
Also, I have sent another email because the first time I purchased, the checkout process did not complete, so I entered my details again..... which resulted in me paying twice for your software.
So, please could you refund me for both of these purchases.
Regards.
Hi James.
Sorry to hear you don't want to use the plugin after purchase.
Although, completely understandable.
You need to log into http://store.tms-plugins.com/ with the credentials you received in your e-mail when you purchased the plugin, then navigate to Purchases/wpDataTables, and if you're still within 15 days from purchase you will see the "Request Refund" button.
You should see both purchases there, so you will be able to refund them through the store.
Best regards.
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
Hmmm, not sure why this would not be a default function. I too just want to add an entry in the middle and can only seem to add to the bottom, and then no way to reorder. Seems like a very common and straight-forward needed function.
Hello Jacqui.
I understand where you're coming from, but wpDataTables is built around the DataTables jQuery plugin, so it needs to follow its rules.
At the moment, there' no way to insert a row at a random position. Similarly to adding a row to the database - you can't just add one in a certain position without affecting surrounding rows.
This is something we will work on in the future, but at the moment, it's not possible.
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,
I haven't been a customer for over 2 years but I am receiving replies to this support ticket.
Please can you delete my user account as I do not wish to purchase any software from you guys right now.
I apologize for that, James.
You opened a public ticket when you reached out to us, so people can respond to it still.
We will delete your account here, so you won't receive any further emails.
Best!
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
I have a need for this as well. I have a set of chronological rows with dates from 1946 to 2023.
Unfortunately my data for 1988 was entered later so it is at the bottom after 2023 and i need it moved up to after 1987;
Is there no SQL command that will move all the rows down by renumbering the wdt_ID columns, creating however many spaces I need to move the 1988 data up?
Hello Ed.
I'm afraid that the workaround provided in one of my earlier responses is still the only way to do this.
Our developers are working on reordering rows, and I hope it will be available in Q1 2024, but I can't make any promises, as the plugin would need to change the IDs of the rows based on the change, so it's not an easy task.
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
A work around that has worked for me is to use the "Excel Like" view to copy the table contents into Excel, reorder and arrange there, then copy-paste back into WPData Tables. Would be nice to have this functionality in a future revision though as it is a basic feature of most table based platforms.
Hi Chris,
Thank you for sharing that workaround idea with us, we will make a note of it.
Thank you for your feedback, we will pass it to our management.
At the moment, unfortunately, we still don't have the featue of easily re-ordering rows for our standard wpDataTables types ( editable tables).
Right now, reordering of rows can only be done with our Simple table type.
If you haven't already, you can affect the development speed for this feature, by upvoting an existing request or creating a new one :
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