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.
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