I have a table that I would like to set a custom background for each row or cell.
We have table CARS,
This table has a row with some information, car_brand, car_type, car_color
I would like to query an api,
and based upon that I would like to change the color to red if the API returns
What happens is that there are a couple things I already tried.
The obvious answers:
- Use the Row Color property, doesn't work with custom queries and logic
table1.rowColor = 'red'doesn't work
- Tried using the background property, again same problem, we can't use queries as functions and then get evaluations, you can use queries that already gave the results
One proposal that should work is that we create a temporary column and then set it to a specific color (change value) based on the API call and then use that column (with Row Color) to simply do the color change.
Any suggestions would be helpful