HTML Table Conditional Row Formatting
I have implemented some conditional formatting using this code in an HTML table:
$(myTable).DataTable({
data: reorderedData,
lengthMenu: itemsPerPageOptions,
columns: colNames,
createdRow: function(row, data, dataIndex) {
var daysOld = data[0]; // Correctly reference the first column
if (daysOld == 1) {
$(row).css('background-color', 'lightyellow');
} else if (daysOld > 1) {
$(row).css('background-color', 'lightcoral');
}
}
});
It works except that the first column (daysOld) is not highlighted. I'm not sure why. What am I doing wrong?
Best Answer
-
The issue appears to be how the datatables library handles rendering. It applies the styles after rendering the data, which appears to be causing it to skip the first column.
You can try applying the formatting during the drawCallback.$(myTable).DataTable({
data: reorderedData,
lengthMenu: itemsPerPageOptions,
columns: colNames,
createdRow: function(row, data, dataIndex) {
// This formatting applies during the row creation phase
var daysOld = data[0]; // First column value (Days Old)
if (daysOld == 1) {
$(row).css('background-color', 'lightyellow');
} else if (daysOld > 1) {
$(row).css('background-color', 'lightcoral');
}
},
// Add a drawCallback function to apply additional formatting
drawCallback: function() {
var table = $(myTable).DataTable();
// Iterate through all rows to ensure formatting applies
table.rows().every(function(rowIdx, tableLoop, rowLoop) {
var data = this.data();
var row = this.node();
var daysOld = data[0]; // Get the value of the first column
if (daysOld == 1) {
$(row).css('background-color', 'lightyellow');
} else if (daysOld > 1) {
$(row).css('background-color', 'lightcoral');
}
});
}
});or target the specific cell in the first column rather than the row.
$(myTable).DataTable({
data: reorderedData,
lengthMenu: itemsPerPageOptions,
columns: colNames,
createdRow: function(row, data, dataIndex) {
var daysOld = data[0]; // First column value (Days Old)
// Apply background color to the first column (specific cell)
var firstCell = $('td', row).eq(0); // Target the first column
if (daysOld == 1) {
$(row).css('background-color', 'lightyellow'); // Entire row
firstCell.css('background-color', 'lightyellow'); // First column
} else if (daysOld > 1) {
$(row).css('background-color', 'lightcoral'); // Entire row
firstCell.css('background-color', 'lightcoral'); // First column
}
}
});
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Answers
-
The issue appears to be how the datatables library handles rendering. It applies the styles after rendering the data, which appears to be causing it to skip the first column.
You can try applying the formatting during the drawCallback.$(myTable).DataTable({
data: reorderedData,
lengthMenu: itemsPerPageOptions,
columns: colNames,
createdRow: function(row, data, dataIndex) {
// This formatting applies during the row creation phase
var daysOld = data[0]; // First column value (Days Old)
if (daysOld == 1) {
$(row).css('background-color', 'lightyellow');
} else if (daysOld > 1) {
$(row).css('background-color', 'lightcoral');
}
},
// Add a drawCallback function to apply additional formatting
drawCallback: function() {
var table = $(myTable).DataTable();
// Iterate through all rows to ensure formatting applies
table.rows().every(function(rowIdx, tableLoop, rowLoop) {
var data = this.data();
var row = this.node();
var daysOld = data[0]; // Get the value of the first column
if (daysOld == 1) {
$(row).css('background-color', 'lightyellow');
} else if (daysOld > 1) {
$(row).css('background-color', 'lightcoral');
}
});
}
});or target the specific cell in the first column rather than the row.
$(myTable).DataTable({
data: reorderedData,
lengthMenu: itemsPerPageOptions,
columns: colNames,
createdRow: function(row, data, dataIndex) {
var daysOld = data[0]; // First column value (Days Old)
// Apply background color to the first column (specific cell)
var firstCell = $('td', row).eq(0); // Target the first column
if (daysOld == 1) {
$(row).css('background-color', 'lightyellow'); // Entire row
firstCell.css('background-color', 'lightyellow'); // First column
} else if (daysOld > 1) {
$(row).css('background-color', 'lightcoral'); // Entire row
firstCell.css('background-color', 'lightcoral'); // First column
}
}
});
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Thanks! I'm going to give these a try.
Is this something that should be reported as an issue?0 -
I went with the second option. It works perfectly. Thanks!
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 635 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 65 App Studio
- 42 Variables
- 701 Automate
- 182 Apps
- 457 APIs & Domo Developer
- 52 Workflows
- 10 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive