I successfully imported date values from xls file.
After some struggle I changed date in excel file to string in format YY-MM-DD (YYYY-MM-DD did not worked).
Search found 237 matches
- 02 Apr 2022, 14:34
- Forum: Discussion
- Topic: Import Date
- Replies: 2
- Views: 204
- 02 Apr 2022, 14:17
- Forum: Discussion
- Topic: Ajax Request table format
- Replies: 4
- Views: 618
Re: Ajax Request table format
Yes, basically it is working if database field is varchar type.
I have in database decimal type field and number is stored only with decimal dot.
I have in database decimal type field and number is stored only with decimal dot.
- 01 Apr 2022, 18:16
- Forum: Discussion
- Topic: Ajax Request table format
- Replies: 4
- Views: 618
Re: Ajax Request table format
Dear Sergey, The Ajax Request is a wonderful function. It transforms the program into a powerful spreadsheet, but with a full php/mysql editable code behind the scenes. I really like this. Just a practical question: how to display the format in the table? Is it possible to achieve this? I can get co...
- 01 Apr 2022, 18:09
- Forum: Discussion
- Topic: Change focus
- Replies: 2
- Views: 253
Re: Change focus
Thank you Sergey, it works.
- 24 Mar 2022, 19:58
- Forum: Discussion
- Topic: Ajax type field - alignment in table
- Replies: 18
- Views: 1118
Re: Ajax type field - alignment in table
Dear Sergey,
if possible, I suggest ajax type field also should correspond to JS formula type field.
In other words, to be able to use ajax-request field in JS formulas.
Or, there is another way to achieve this (by javascript etc)...?
Thank you.
if possible, I suggest ajax type field also should correspond to JS formula type field.
In other words, to be able to use ajax-request field in JS formulas.
Or, there is another way to achieve this (by javascript etc)...?
Thank you.
- 24 Mar 2022, 18:29
- Forum: Discussion
- Topic: Change focus
- Replies: 2
- Views: 253
Change focus
Dear all... I am stuck with moving focus to input field once value in entity ajax field is changed. This is my code (in javascript form): $('#fields_3538').on('change', function() { $('#fields_3496').focus(); }); fields_3538 is entity ajax (drop-down) fields_3496 is input field. When the value in dr...
- 23 Mar 2022, 15:43
- Forum: Discussion
- Topic: Date format in table
- Replies: 3
- Views: 248
Re: Date format in table
Thank you.
I understand that, but how to convert it in table?
I understand that, but how to convert it in table?
- 23 Mar 2022, 13:51
- Forum: Discussion
- Topic: Date format in table
- Replies: 3
- Views: 248
Date format in table
Dear Sergey, dear all, is there a way to format date in table listing to show d-m-Y instead of integer value? I am pulling date from other table and managed to show it correctly inside form: DMS_form.png But in table listing, the value is presented as integer value and I cannot figure out how to cha...
- 13 Mar 2022, 18:49
- Forum: Discussion
- Topic: Ajax type field - alignment in table
- Replies: 18
- Views: 1118
Re: Ajax type field - alignment in table
Thank you.
- 13 Mar 2022, 18:48
- Forum: Discussion
- Topic: Filter for active or inactive user
- Replies: 15
- Views: 837
Re: Filter for active or inactive user
Und im Falle dass man benutzt "msq"?
msq.field_xxx
msq.field_xxx