Hey everyone!

With the Labour Day holidays coming up, we’d like to let you know about our upcoming working hours:

Thursday, May 1st: Our team will be off during Labour Day.
Friday, May 2nd: We'll also be off for an extended holiday break.

We’ll be back on Monday, May 5th, ready to respond to all messages received during this time.

In the meantime, if you need help, feel free to:

https://www.youtube.com/@AmeliaWordPressBookingPlugin/videos

https://www.youtube.com/@wpDataTables/videos

Thank you for being so understanding, and we hope you enjoy the long weekend! 

Okay
  Public Ticket #2720352
Blank fields being populated with 0
Closed

Comments

  •  1
    Meg started the conversation
    March 14, 2021 at 11:28pm

    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

  • [deleted] replied
    March 16, 2021 at 7:41am

    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

    8267013590.png


  • Jorge Manrrique replied
    May 14, 2021 at 11:59pm

    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
  • [deleted] replied
    May 17, 2021 at 3:07pm

    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.

  • [deleted] replied
    May 18, 2021 at 7:46am

    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.

  • Jorge Manrrique replied
    May 19, 2021 at 2:29pm

    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
  • [deleted] replied
    May 19, 2021 at 3:20pm

    You are most welcomesmile.png

    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.



  • Jorge Manrrique replied
    May 20, 2021 at 4:59pm

    Of course I am, delighted, I do it right now

  • [deleted] replied
    May 21, 2021 at 7:38am

    Thank you, we really appreciate itbigsmile.png 

    If there is anything else we can do for you please don't hesitate to let us know.

    Have a wonderful day!