Help

Re: Color coding functionality

Solved
Jump to Solution
1145 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Tanzugirl23
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello! Is there a way to create a notification (using the color function) highlighting an expiration date in my Airtable to alert me five months before an asset expires?

1 Solution

Accepted Solutions
Tanzugirl23
5 - Automation Enthusiast
5 - Automation Enthusiast

Your response was very helpful. I used the conditions option to color-code my renewal dates.  Thank you!

See Solution in Thread

2 Replies 2
Andy_Lin1
9 - Sun
9 - Sun

You can colour code records based on the condition

"Where {Expiration Date} [is on or before] [number of days from now] '150' "

Alternatively, you can set up an email automation using the trigger "When a record matches conditions" with the condition above.

If you want it to be part of a record, you can set up a formula field with the formula (you can use anything to represent it, I just picked the red exclamation mark emoji).

IF(DATETIME_DIFF({Expiration Date},  TODAY() , "M") < 6, "❗")

 

Tanzugirl23
5 - Automation Enthusiast
5 - Automation Enthusiast

Your response was very helpful. I used the conditions option to color-code my renewal dates.  Thank you!