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.
Can you try and test if this is a bug, possible to solve it. Thanks!
The field type "Date with calendar picker" under the section at Date with calendar picker
-
- Posts: 70
- Joined: 14 Apr 2017, 10:50
- Name: Bernard Lee
- Location: Singapore
-
- Posts: 70
- Joined: 14 Apr 2017, 10:50
- Name: Bernard Lee
- Location: Singapore
Re: Date with calendar picker
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
- Site Admin
- Posts: 6215
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Date with calendar picker
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.
-
- Posts: 70
- Joined: 14 Apr 2017, 10:50
- Name: Bernard Lee
- Location: Singapore
Re: Date with calendar picker
Noted, shall avoid using "default value" and "unique field" together. Either one to be used only to avoid conflict. Thanks!