-
Hello boonexpert !
As you know from our discussion in Messenger, I don't consider that this is a bug. Because the empty value is the value too. And could be used by 1 user :-) If this is not OK then you need to add the Mandatory check for non-empty value too.
-
I work with web for the past 16+ years and It’s a simple logic.
Wow, definitely the time period of my work in Boonex for now!
You being so lordly. Great support from such an arrogant staff. Thanks.
So you compare the empty form field - nothing to nothing - thinking of "nothing" as of data. Cool.
So the field cannot be left empty, no matter if "mandatory" is off. So "mandatory" flag doesn't make any sense if I want to leave it empty. I never can leave the field empty. So it's "mandatory" in each case.
I have no more words to say.
-
Sorry, didn't have any intentions of being "arrogant". Regarding our problem - if in the MySQL table you will make some field as UNIQUE and then add 1 record without filling this field then you can't add other records by this way (not value for this field) too.
-
Right.
The website is not just clear MySQL, it has some logic written in PHP. Which should check if "mandatory" is off, "unique" is on, then if field is empty or not, also by trimming spaces - and if it's empty - to not do anything. If not empty - then check if entered value is unique by db table.
If I want users to be able to leave the field empty, I should uncheck "mandatory".
If I want them to fill it with any data, I should check the "mandatory".
Simple. It works like this on all platforms.