Unfortunately integer type does not support null values in the cells when they are opened for editing. It will automatically add a 0 value as it is default value for the integer.
I also asked my team about this to see if it is possible to deliver the null value to an integer while editing.
I will get back to you when I got an answer from them.
Sorry for late response, it took us some time to discuss about this.
Unfortunately html5 input type=number (that we are using) doesn't work with empty value and it is not possible to have empty value because the default value for integer column is 0 and not null.
One workaround is to make that column to be string but it will break the sum average or any other mathematical function that is applied to integer column.
I have an editable table with several integer fields that contain null values.
However, when after editing and saving a record, all of these integer fields now have a 0 rather than null, which messes up the Average calculation.
Please advise.
Hi jjanicik,
Thank you for your purchase.
Can you please send me the link of that table so I can take a look.
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
Hi jjanick,
Unfortunately integer type does not support null values in the cells when they are opened for editing. It will automatically add a 0 value as it is default value for the integer.
I also asked my team about this to see if it is possible to deliver the null value to an integer while editing.
I will get back to you when I got an answer from them.
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 to have this changed so that the data entered and the average summation would be accurate.
Thanks, Bogdan.
Hi jjanick,
I am still waiting for an answer.
Just to keep you updated.
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
Any word back from the developers on this one yet?
Hi jjanick,
Sorry for late response, it took us some time to discuss about this.
Unfortunately html5 input type=number (that we are using) doesn't work with empty value and it is not possible to have empty value because the default value for integer column is 0 and not null.
One workaround is to make that column to be string but it will break the sum average or any other mathematical function that is applied to integer column.
Sorry for any inconvenience.
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