AppGini Community Forums

If you wish to turn the default date picker (3 selects + 1 button) ...


... into a single line datepicker ...


... with only one line of javascript code ...

... you should have a look here:
https://appgini.bizzworxx.de/products/j ... atepicker/

Attention
This will work for datetime fields and not for date fields. So you need to change the field type first, re-generate your app and check Rebuild Fields in admin-Area.

hi Jan
but in this case
being the datetime field; how is the data entered?
'2019-11-20 00:00:00'
or '2019-11-20' only?

thanks

sorry, I asked a stupid question, it's obvious that it's 2019-11-20 00:00:00.
but if we need to display only the date in table-view?

thanks

It's not a stupid question at all, thank you for pointing that out!

You can format your table view values in "Data format" in the field properties:

If there is no suitable format inside the list, feel free to create your custom format.


Best,
Jan

G Belgrado wrote: ↑

2019-11-27 11:51

sorry, I asked a stupid question, it's obvious that it's 2019-11-20 00:00:00.
but if we need to display only the date in table-view?

I have updated the documentation. There is a short description of how to change the data format in table view.
https://appgini.bizzworxx.de/products/j ... atepicker/

There is also a modified dataFormats.cfg file for download (zip-file) which already includes formats y/m/d, y-m-d and d.m.y

now it's okay
Thanks Jan


other question:
in my project. apx with bootstrap theme
I have the localization settings as I need. (time zone europe\rome ; date format day month year)

in your code Is it possible to have the datepicker in another language?

or it depends on
AppGini\files\resources\bootstrap-datetimepicker\bootstrap-datetimepicker.min.js


thanks a lot for your time

Solved.
Need to set in language.php on 'it'

thanks again Jan

That's right. The code will use the locale setting as it has been configured in your AppGini project.

Anyway, you can pass a different locale as first argument (string) to the .toDatepicker method.

But be careful: the value has to be converted and stored in your datetime database field. Both formats, MySQL and Javascript must match. Try carefully before using a different locale!

jsetzer wrote: ↑

2019-11-28 12:26

Anyway, you can pass a different locale as first argument (string) to the .toDatepicker method.

you mean .toDatepicker() .toDatepicker('it')
true?

Yes, I have just checked the underlying moment.js library and your locale should be "it".
This is the datepicker with Italian UI:

Please also have a look at your project settings:

Hi Jan, All,

I can't seem to get the .toDatepicker() to take. I have the following line of code
new AppGiniField("Donation_Date").toDatepicker();

I have specified the type DateTime. I can see it in FF debugger go to the AppGiniHelper.min.js library but it seems to get overwritten because the image shows the time (in addition to date) and it puts the time in the textbox after selection. I have applied the Data Formats as you have documented. I have another DateTime field on the form that for now I'm using as a control, not using AppGiniHelper, and it behaves the same way, shows some other datepicker. I know the AppGiniHelper libary is working because I have changed the title and icon on the main menu, and I even added a .hide() line right below this line, just to test, and the field does get hidden. My problem seems to be specific to toDatepicker.

I'm not good enough at JQuery to do much debugging. It seems to me that there is some order of operations and the datepicker from the helper is superceded. I did a view source and I see

jQuery('#Donation_Date').addClass('always_shown').parents('.input-group').datetimepicker({ toolbarPlacement: 'top', sideBySide: true, showClear: true, showTodayButton: true, showClose: true, icons: { close: 'glyphicon glyphicon-ok' }, format: AppGini.datetimeFormat('dt') , locale: 'en' });

identical except for the field name to the other DateTime field on the form.

Any help appreciated. Thanks.

Paul

Using BigProf AppGini 5.82

Hi Paul,

thanks for your detailed bug report. I confirm there is a problem with toDatepicker() with generated code of latest AppGini version. Gonna do some research.

Regards,
Jan

A little work but thats how I manage datetime pickers:

https://www.hongkiat.com/blog/jquery-ui-datepicker/

I found out how to use the AppGini native to get what I want (at least I think it works), thanks to another post of yours, https://bigprof.com/blog/appgini/how-to ... ime-field/

The format of the field needs to be DateTime.
In the _dv hook, add