Conditional table cell - text color

[melohagan]

As this feature has been requested a few times, I thought it would be worth adding a tutorial on how to implement this using the wonderful Super Table component by @poirazis

A common use-case is to highlight cells in a different color depending on a status value.

To begin using it, follow the quick guide on Importing plugins.

The Super Table is a multi-part custom component plugin requiring the following imports:

• Super Table
• Super Column
• Super Cell

Once those components have been imported, create a new app with the sample data. Add a screen with a Data provider for the Inventory table.

Under the Data provider, nest the Super Table, and then nest a Super Column for each of the table columns you want to display.

Under the Super Column that was added for the Status column, nest a Super Cell. In the Conditions tab of the cell, click Configure conditions and setup the following, using the duplicate icon button to speed things up. Make sure to click Save!

The binding in each case comes from the Status column binding:

Result

[xnohat]

Superb plugins , that all we need <3

[jo-chla]

Hi, I have installed the Super Table/Column/Cell plugins, but was wondering is there a way to have the Font Color of a cell change if the value of that cell already exists in the column?

For example, if "Name" column contained "Jeff, Sam, Mike, Mike, Jeff, Jeff", the cells with "Jeff" and "Mike" would all be a certain color.

[melohagan]

Hey @jo-chla You may be able to do this with a Data provider. This approach would be limited to checking the names within the limit set by the data provider.

But then your Update setting condition would use something like: IF "Mike" Is In Binding {{ pluck Data provider.rows 'Name' }}

[jo-chla]

Thanks! However I have tried with a numerical column:
IF {{ New Super Table Column.Cell Value }} IS IN Binding {{ pluck Data provider.rows 'ID_Number' }}
And it is not updating the color of entries that already exist in ID_Number column

Another question would it be better to do in the budibase backend database interface which is much faster?
I have tried creating a function column in MyTable:
{{ #inArray ( pluck MyTable.rows 'ID_Number' ) ID_Number }} Duplicate {{/inArray}}
but it hasn't been working

[cyberz0mbie]

Does this work with the latest version of budibase, I set mine up to your example and i do not get anything on my screen

[ahmedelnaqa]

hi,
I try to highlight "change row background colour" based on the date of DateColumn=today

thanks