Date with calendar picker

[bernard.lee]

The field type "Date with calendar picker" under the section at Extra allowed to check the box as 'Unique field'.

The 'Unique field' therefore is unique to prevent the same date from creation for this particular field type "Date with calendar picker".

For example date, no similar date is allowed if a date has been created before, 2019-05-11 (yyyy-mm-dd). If you create by accidentally again by inputting a new record with the same date, 2019-05-11 it will be prompted with the message "The field value must be unique".

However, [the bug] if you have also set the "Default Date" to "0" which is reflected auto the current date when you add a record.

When you immediately enter and save the record. It will actually skip the verification and saved the record.


And you will see a duplicate same date appeared in your list record.

Screenshot 2019-05-11 at 4.19.30 PM.png (22.32 KiB) Viewed 2444 times

Can you try and test if this is a bug, possible to solve it. Thanks!

[bernard.lee]

Further to above, when you inputting manually with a similar date which has already been recorded. You will be prompted with the message "The field value must be unique".

[support]

Yes, default value and and unique flag are conflicted, because we check value once select value from calendar. Without it we don't know which value need to check.

[bernard.lee]

Yes, default value and and unique flag are conflicted, because we check value once select value from calendar. Without it we don't know which value need to check.

Noted, shall avoid using "default value" and "unique field" together. Either one to be used only to avoid conflict. Thanks!