I have a table set up to display fields as an integer. But it is displaying empty fields as 0. I want blank fields to remain empty - an only fields that are actually populated with a 0 to show a 0.
If possible, I would like blank fields to display in a particular colour.
Could you please tell us from which source file did you create the table?
If it is created from a base that has NULL values it should show blank cell instead of adding a 0, like Excel for example. Could you send us the source file so we can take a look?
For integer columns it is not possible to set conditional formatting for empty values, we can suggest using a string type column and setting conditional formatting like on the image below
On this conditional format, is it possible that the data that is colored is only the number inside the cell and not the whole cell?
I have 3 rows 1 column
in row one the value in the cell is 10 (positive) in row 2 the value in the cell is 0 and in row 3 the value in the cell is -10 (negative), what I am looking for is that the number 0 is white, the number (positive) 10 is green and the number (negative) -10 is red, is this possible?
In the example images the whole cell is colored (and the numerical data is always white), but I am looking to color only the numerical data inside the cell
thank you very much in advance for your reply
Unfortunately this is not possible using the plugin's builtin options, but I have forwarded this to our developers to take a look. In case there is some custom CSS they can provide I will forward it straight over to you.
Wow, thank you very much, I really never believed that you would give me a useful answer in this way, but I was wrong, you and your team are great thank you very much.
And I know that the answer is useful, because I had already discovered it before, but if I had not discovered it by my own means, before your answer, obviously with full certainty I would have discovered in this, your answer, that this is how you get the result.
Thank you
Thank you for your kind words, we do our best to help as much as we can.
If you have any other issue or question please open new ticket, and we will help you out.
I would like to ask you a favor. Would you mind taking a few minutes to write a review for us, please on this link?
Our free version is the only place where we can have proof for our hard work; your comments are beneficial for others to know what to expect when they’re looking for our plugin.
Thank you in advance. It means a lot to us, and I am looking forward to reading your comment.
I have a table set up to display fields as an integer. But it is displaying empty fields as 0. I want blank fields to remain empty - an only fields that are actually populated with a 0 to show a 0.
If possible, I would like blank fields to display in a particular colour.
Is there a way to make this happen?
Thanks!
Meg
Hi Meg
Thank you for reaching out to us.
Could you please tell us from which source file did you create the table?
If it is created from a base that has NULL values it should show blank cell instead of adding a 0, like Excel for example. Could you send us the source file so we can take a look?
For integer columns it is not possible to set conditional formatting for empty values, we can suggest using a string type column and setting conditional formatting like on the image below
Hi Jorge
Unfortunately this is not possible using the plugin's builtin options, but I have forwarded this to our developers to take a look. In case there is some custom CSS they can provide I will forward it straight over to you.
Hi Jorge
You can add a rule that applies custom CSS class to the cell (for example "abcf"). Then, in Customize/Custom CSS, you can add custom CSS like:
table.wpDataTable .abcf {
color:green;
}
And only the text inside the cell will be colored green.
You are most welcome
Thank you for your kind words, we do our best to help as much as we can.
If you have any other issue or question please open new ticket, and we will help you out.
I would like to ask you a favor. Would you mind taking a few minutes to write a review for us, please on this link?
Our free version is the only place where we can have proof for our hard work; your comments are beneficial for others to know what to expect when they’re looking for our plugin.
Thank you in advance. It means a lot to us, and I am looking forward to reading your comment.
Of course I am, delighted, I do it right now
Thank you, we really appreciate it
If there is anything else we can do for you please don't hesitate to let us know.
Have a wonderful day!