Topic: Datatable Cells format function not changing colors on table render.

Twizza priority asked 1 month ago


What I am expecting to happen is that whenever I filter the datatable or paginate the table, the format function on the tables cell to run and change the color based on what is shown. I thought maybe I was doing something wrong, but I see it also does it on your example of the datatable cells format

It seems the color gets rendered onto the cells style attribute the first time around, but then never happens again whenever the table is re-rendered or filtered or anything. I believe this might be a bug in your datatable, but I could be wrong.

as you can see here, when the page loads these are in the correct positions because it renders them happily the first time around where the should beBut now they are incorrect when I filter, as it seems the cells format function doesn't change what is already there even though it does run.

{
    label: 'Status',
    field: 'status',
    format: function (cell, value) {
        switch (value) {
            case 'Draft':
                cell.style.backgroundColor = 'rgba(23, 162, 184, 0.8)';
                break;
            case 'Submitted For Approval':
                cell.style.backgroundColor = 'rgba(255, 193, 7, 1)';
                break;
            case 'Awaiting Approval':
                cell.style.backgroundColor = 'rgba(253, 126, 20, 0.8)';
                break;
            case 'Approved':
                cell.style.backgroundColor = 'rgba(0, 123, 255, 0.8)';
                break;
            case 'Rejected':
                cell.style.backgroundColor = 'rgba(220, 53, 69, 0.8)';
                break;
            case 'Awaiting Invoice':
                cell.style.backgroundColor = 'rgba(149, 53, 83, 0.8)';
                break;
            case 'Invoice(s) Received':
                cell.style.backgroundColor = 'rgba(40, 167, 69, 0.5)';
                break;
            case 'Complete':
                cell.style.backgroundColor = 'rgba(40, 167, 69, 1)';
                break;
            default:
                cell.style.backgroundColor = 'transparent';
                break;
        }

        cell.style.color = 'white';
        cell.style.textAlign = 'start';
    },
},

Grzegorz Bujański staff answered 1 month ago


Unfortunately, I am unable to provide the exact release date. We are currently working on a major update of the MDB package and the next version will probably not be released until September.


Grzegorz Bujański staff answered 1 month ago


Yes, it's a component bug. Thanks for reporting. We will fix it as soon as possible.


Twizza priority commented 1 month ago

Thank you, is there any chance there is an ETA on how long a fix like this would take ? I need to know as we are pushing to prod soon and I need to know whether to find a different way around this



Please insert min. 20 characters.

FREE CONSULTATION

Hire our experts to build a dedicated project. We'll analyze your business requirements, for free.

Status

Answered

Specification of the issue

  • ForumUser: Priority
  • Premium support: Yes
  • Technology: MDB Standard
  • MDB Version: MDB5 7.3.2
  • Device: Desktop PC
  • Browser: Chrome
  • OS: Windows
  • Provided sample code: No
  • Provided link: No