# Use Airtable Formulas to Filter & Countdown

**URL:** <https://community.stackerhq.com/t/use-airtable-formulas-to-filter-countdown/81>\
**Category:** Automations\
**Created:** [February 27, 2021, 12:28am UTC](https://community.stackerhq.com/t/use-airtable-formulas-to-filter-countdown/81 "2021-02-27T00:28:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chelsea](https://dub1.discourse-cdn.com/flex017/user_avatar/community.stackerhq.com/chelsea/32/48_2.png) [@Chelsea](https://community.stackerhq.com/u/Chelsea)\
**Post date:** [February 27, 2021, 12:28am UTC](https://community.stackerhq.com/t/use-airtable-formulas-to-filter-countdown/81/1 "2021-02-27T00:28:07Z")

</div>

Good use of an Airtable formula can provide your users with valuable information and add detail to your Stacker app. In this tutorial, I will use an Airtable formula to calculate the days until a specific event.

I have a ‘date’ field in my events table. I have also added a formula field that will be used to calculate days until the specific date:

 ![Screen Shot 2021-02-26 at 3.44.53 PM](https://europe1.discourse-cdn.com/flex017/uploads/stacker/original/1X/8f1b2b7169b9287c28ee6a8e364cd6b5bc6f1483.png)

If the ‘days until event’ is positive, the event is in the future. If it is negative, the event has already passed. I can use this logic to create multiple layouts from my table (i.e. ‘upcoming events’ and ‘past events’).

 ![Screen Shot 2021-02-26 at 4.24.02 PM](https://europe1.discourse-cdn.com/flex017/uploads/stacker/original/1X/dc43ae9bbc04daa6661745015341877992b1a1cd.png)

 ![Screen Shot 2021-02-26 at 4.24.13 PM](https://europe1.discourse-cdn.com/flex017/uploads/stacker/original/1X/5d1d4f5bfeda4fabc34379347e76ab58a5f11d44.png)

I can even add a banner with conditional visibility to show when the event is less than a week away:

 ![Screen Shot 2021-02-26 at 4.10.31 PM](https://europe1.discourse-cdn.com/flex017/uploads/stacker/original/1X/f2c1b2561b125c3de5ba849914477acc4ae3accb.jpeg)

This is especially useful if you have an expiration date coming up and would like to warn your users.

---

<div class="post-metadata">

**Author:** ![ariszagklis](https://dub1.discourse-cdn.com/flex017/user_avatar/community.stackerhq.com/ariszagklis/32/306_2.png) [@ariszagklis](https://community.stackerhq.com/u/ariszagklis)\
**Post date:** [November 11, 2021, 7:25pm UTC](https://community.stackerhq.com/t/use-airtable-formulas-to-filter-countdown/81/2 "2021-11-11T19:25:42Z")

</div>

That’s excellent!!! And i was wondering how to use, all these secondary fields i am using to get useful infos.