The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Aug 28, 2023 04:50 PM
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?
Solved! Go to Solution.
Aug 29, 2023 04:15 PM
Your response was very helpful. I used the conditions option to color-code my renewal dates. Thank you!
Aug 29, 2023 12:07 PM - edited Aug 29, 2023 12:11 PM
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, "❗")
Aug 29, 2023 04:15 PM
Your response was very helpful. I used the conditions option to color-code my renewal dates. Thank you!