Page 1 of 1

Date with calendar picker

Posted: 11 May 2019, 12:25
by bernard.lee
Screenshot 2019-05-11 at 3.48.24 PM.png
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".
Screenshot 2019-05-11 at 3.48.02 PM.png
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".
Screenshot 2019-05-11 at 4.16.42 PM.png
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
Screenshot 2019-05-11 at 4.19.30 PM.png (22.32 KiB) Viewed 2724 times
Can you try and test if this is a bug, possible to solve it. Thanks!

Re: Date with calendar picker

Posted: 11 May 2019, 12:28
by 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".

Re: Date with calendar picker

Posted: 11 May 2019, 14:08
by 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.

Re: Date with calendar picker

Posted: 11 May 2019, 18:32
by bernard.lee
support wrote: 11 May 2019, 14:08 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!