Wappler Version : 2.1.5
Operating System : Mac OS
What do you think should happen?
I have a datepicker on a form that works fine. My expected behaviour would be that if no date is picked it would leave the data in that field empty.
What actually happens?
If you do not select a date it enters 0000-00-00 as the date in the table.
Add a datepicker to a form and submit form without picking a date.
I had the same experience. When I set the data field in the database to accept null values, it would produce an undefined entry in the data picker.
So my solution was to not accept null values in the data field, which resulted in the 0 database entries you are seeing.
However, the end user should not see the 0’s. I don’t see them on my front end.
It shows as January 1, 1900 in the front end.
Set a condition in your update query
This basically says “On condition that there is something in this field then update this field, otherwise ignore it”.
