Row of table automatically changes color after the due date has passed

Ask for Help
1

Not a native speaker so my english is going to be difficult to understand. Sorry in advance.

So i am working on a project of interest, where it has a lot of dates, i want the color of the date changes when the due date passes. For example today is 6/2/2025, and today passed 5/2/2025, so the row of 5/2/2025 changes to color red.
It would also be great if it could deduct the final value of the money after the interest ends. For example the interest suppose to end in 7/2/2025, and when 7/2/2025 comes, the amount of interest in the bank deduct from 100000 to 60000, reducing the money of the interest that is finished, and the remaining 40000 is of another interest plan.
For example:
Total amount in 6/2/2025:X+Y+Z
->(after the interest plan ends and i claimed my money in 7/2/2025) →
Total amount = X+Y, where Z was taken out on 7/2/2025

I would appreciate any help given. Thank you in advance :heart:

2

Sure, all this will take is to have a math column and conditional visibility depending on what type of component you have. If you share how your component looks, it’ll be easier to assist you.

3

image
image1250×451 103 KB

something looks like this

4

I meant the interface :slight_smile:

5

So the “color” is something on the front end right? Can it just be a circle to denote the “status” of that row?

Is the “final value” a column in that same table?

6

the color if possible i would hope to highlight the whole row. it would not be effective if it is a circle since my client would like to know which of the interest ended so he/she can withdraw the money for another investment. Highlighting the whole row would be more systematic and have better understanding.

The final value is a column in the same table

7

the interface is just a table like this. nothing more

8

Does your plan support custom css?