Font colors for data at tables from a dataset

Ask the community
,
2

You can do it with code.
Let’s say the column of number is under a data field key named ‘val’ which is of type: Number. Then:

const getColor = (num) => num > 0 ? 'green' : num < 0 ? 'red' : 'black';
$w.onReady(() => {
$w('#dataset1').onReady(() => {
$w('#table1').columns = $w('#table1').columns.map(e => {
if(e.dataPath === 'val') {e.type = 'richText';} return e;});
$w('#table1').rows = $w('#table1').rows.map(e => {e.val = `<p style="color:${getColor(e.val)};">${e.val}</p>`; return e;});
})
});