I'm SO close to achieving what I want, I'm amazed with WPDataTables.
The text under the Description field of the table (accessible from URL) is more than 255 characters. I LOVE that I can expand the table rows, and I love the HTML Editor, and tried out the Drop Down select boxes.
I'm stuck at the length of text. I read the bit about the MySQL column having to be either VARCHAR or TEXT, do I need to access that table in the database and edit the column type in MySQL?
Some of the records I need to include in the Description field can go up to 1000 characters.
Thank you for your purchase, and for your kind words.
Since you already created the table, you will need to modify the column through PHPMyAdmin. For future reference, when you're creating a table and want to add a column which has long text in it, you just need to modify the editor input type and change it from "Single-line" to "Multi-line" edit.
To make changes to this table, you need to do make the same change:
Then, when you go to PHPMyAdmin and access the Structure of that table, hit "Change" for the "Description" column, and in a new window that appears, change VARCHAR to TEXT and remove the character limit:
When you save this, clear browser cache and refresh the page, and it should apply the changes.
I followed the steps and went ahead and created a new table with the criteria set correctly and it works great. The items display and expand to show full text. This great. I showed the client and they were pleased. Thanks so much for the support and again, sorry for the late reply, you have a great product. Thank you!
I reviewed your KB (https://wpdatatables.com/documentation/front-end-editing/editor-input-types/).
I'm SO close to achieving what I want, I'm amazed with WPDataTables.
The text under the Description field of the table (accessible from URL) is more than 255 characters. I LOVE that I can expand the table rows, and I love the HTML Editor, and tried out the Drop Down select boxes.
I'm stuck at the length of text. I read the bit about the MySQL column having to be either VARCHAR or TEXT, do I need to access that table in the database and edit the column type in MySQL?
Some of the records I need to include in the Description field can go up to 1000 characters.
Thanks in advance,
dg
Hello UAG-WPEnvato
Thank you for your purchase, and for your kind words.
Since you already created the table, you will need to modify the column through PHPMyAdmin. For future reference, when you're creating a table and want to add a column which has long text in it, you just need to modify the editor input type and change it from "Single-line" to "Multi-line" edit.
To make changes to this table, you need to do make the same change:
Then, when you go to PHPMyAdmin and access the Structure of that table, hit "Change" for the "Description" column, and in a new window that appears, change VARCHAR to TEXT and remove the character limit:
When you save this, clear browser cache and refresh the page, and it should apply the changes.
I hope this helps.
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
Hello, I'm sorry for my late reply!
I followed the steps and went ahead and created a new table with the criteria set correctly and it works great. The items display and expand to show full text. This great. I showed the client and they were pleased. Thanks so much for the support and again, sorry for the late reply, you have a great product. Thank you!
You're welcome UAG-WPEnvato.
Glad I could help.
If you have any more issues or questions feel free to open a new ticket, we will gladly help.
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