We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
Hello, sorry for what must be a common function. We searched the existing Help. We just purchased the plugin and are going through some basic due diligence.
How do we set that a field/ column only contains unique entries?
e.g. a Table of People's contact details might set the mobile phone column/ field to be unique (unless people share a mobile phone)?
Regards
John
Hello John
To create a unique column in wpDataTables, your table needs to be a server-side table (manual, SQL Query based, or imported).
The column cannot be "TEXT", but it can be "VARCHAR", or "INT". Then, you can add this SQL in PHPMyAdmin:
That will make that column unique, and duplicate values will not be accepted, so wpDataTables will display an error like this:
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 Aleksander
Thank you for your reply.
I went through those steps. Thanks.
The amount of effort to configure non-duplicate entries is far beyond what we expected. You already have a tick box to request that an entry is not empty. This is of the same scale. There is no way I can ask users to go into PhpMyAdmin to find the table and column names and enter that code.
Regards
John
Hi again John
I understand. While setting a column as mandatory is relatively easy, the only way of checking if an entry is duplicated is as I explained in my previous response.
Sorry for the inconvenience.
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
Dear Aleksandar
Thank you again. OK, I will see what we can do to work-around this if possible.
Regards
John
You're welcome John.
I guess you saw that we have hooks and filters available, but in case you missed them - here are the links. They may come in handy.
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
(ignore this)