search

melohagan / budibase-component-kasper-date-picker

Date picker with text input with options to set format, locale, show/hide calendar. Adapted from the Kasper date picker.
11 stars 6 forks source link

If a date format is entered, the database value will not be shown in the field #3

Closed agruenberg closed 2 years ago

agruenberg commented 2 years ago

I added the date-picker to a update form and changed the date format to dd.MM.yyyy. Afterwards I launched this form and the value, that should be shown there, is not appearing (see attached Video). The settings are the same as for the build-in date-picker (see attached screenshot). Bildschirmfoto von 2022-10-19 16-42-51

vokoscreen-2022-10-19_16-25-10.webm

melohagan commented 2 years ago

Hey @agruenberg

Would be be able to show me your Save Row action?

agruenberg commented 2 years ago

Sure Bildschirmfoto von 2022-10-19 16-47-18

melohagan commented 2 years ago

And the form schema is set to invoices and the form field for the date-picker is set to Date of Invoice with the correct capitalisation of your table column?

agruenberg commented 2 years ago

Yes, as defined in the screenshot. It is the same definition as before, only the component has changed. Before I used the build in picker. The selected value is also transferred to the database as you can see in the video (with -1 day, but this is an extra issue). Only the loading and showing within the component seems not to work.

melohagan commented 2 years ago

Perfect, and finally what is your timezone? Just in case that would cause issue.

agruenberg commented 2 years ago

Austria, Vienna GMT+2 ;)

melohagan commented 2 years ago

Hey @agruenberg

I've added an option to ignore timezone. I think what may have been happening here is that when you saved the row to the database, the value was being set as ... 12 23:00:00 instead of ... 13 00:00:00

So upgrade and make sure this setting is ticked: Screenshot 2022-10-21 at 16 14 13

Let me know if that fixes it for you! I'll re-open the issue if the problem still persists.