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