Hi, I am having the old issue with the date time fields format with wpdatatables. Has there been any work to improve this? The format I need wpdatatables to work with is yyyy-dd-mm.
Since I had to force the field to be a string to work, how can I force my users to type in a specific format? Is there a way to apply an input mask to a specific field?
I found a workaround using a MySQL trigger to reformat the data and insert/update it into the destination column. It would still be nice to be able to apply specific masks to fields.
A lot of other plugins have a capability to hook into their plugin using a custom functions.php. Is it possible to do this with wpdatatables? If so, are there any example functions you have available?
I see it is possible to choose different Date and Time formats in the settings portion of WPDatatables. Can I add a new format to choose there? Right now when my SQL date is 0000-00-00 00:00:00 it shows as 11/30/-0001 00:00 in WPDatatables. My column type is DateTime.
There has to be a better way to handle this since that MySQL date format is fairly common. Thoughts?
It would be nice if we could have the ability to add our own custom masks when building a wpdatatable. It could be a simple field that you add to the columns where you can define the mask. I've used this js in another plugin. https://igorescobar.github.io/jQuery-Mask-Plugin/docs.html
Hi, I am having the old issue with the date time fields format with wpdatatables. Has there been any work to improve this? The format I need wpdatatables to work with is yyyy-dd-mm.
Since I had to force the field to be a string to work, how can I force my users to type in a specific format? Is there a way to apply an input mask to a specific field?
Hi jko5er,
Thank you for your purchase.
That date format is on our TODO list and we will definitely consider implementing it for some of our next future versions.
In your case maybe you can change the display header, for example
Date ( yyyy-dd-mm )
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
I found a workaround using a MySQL trigger to reformat the data and insert/update it into the destination column. It would still be nice to be able to apply specific masks to fields.
A lot of other plugins have a capability to hook into their plugin using a custom functions.php. Is it possible to do this with wpdatatables? If so, are there any example functions you have available?
HI jko5er,
The list of all available hooks and actions are in our documentation.
https://wpdatatables.com/documentation/information-for-developers/filters/
https://wpdatatables.com/documentation/information-for-developers/hooks/
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
I see it is possible to choose different Date and Time formats in the settings portion of WPDatatables. Can I add a new format to choose there? Right now when my SQL date is 0000-00-00 00:00:00 it shows as 11/30/-0001 00:00 in WPDatatables. My column type is DateTime.
There has to be a better way to handle this since that MySQL date format is fairly common. Thoughts?
HI jko5er,
Yes you can add the new formats to the plugin but please make a backup of that files because the next update will overwrite it.
Also please note that to achieve something like this requires a lot of files to be changed and it is not easy as it looks.
Also from the replies below the new date and datetime formats are on our TODO list to add a few more for future updates.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
It would be nice if we could have the ability to add our own custom masks when building a wpdatatable. It could be a simple field that you add to the columns where you can define the mask. I've used this js in another plugin. https://igorescobar.github.io/jQuery-Mask-Plugin/docs.html
Hi jko5er,
I will forward your suggestion to my team so we can discuss if this can be added as a built in feature for some next updates.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables