As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
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)