# Triggers or Auto Updated information on User End **URL:** \ **Category:** Ask for Help\ **Created:** [July 14, 2021, 12:49am UTC](https://community.glideapps.com/t/triggers-or-auto-updated-information-on-user-end/29059 "2021-07-14T00:49:52Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Sage\_Edutitrof](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sage_edutitrof/32/28772_2.png) [@Sage\_Edutitrof](https://community.glideapps.com/u/Sage_Edutitrof)\ **Post date:** [July 14, 2021, 12:49am UTC](https://community.glideapps.com/t/triggers-or-auto-updated-information-on-user-end/29059/1 "2021-07-14T00:49:52Z")
How can I create information to automatically populate on the user end. For example, let’s say an admin adds update information for the next day’s announcements. I would like the other users to see it automatically populate. To be more clear, when they open items for a particular day, the next day and day of information populates on their screen. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 14, 2021, 1:07am UTC](https://community.glideapps.com/t/triggers-or-auto-updated-information-on-user-end/29059/2 "2021-07-14T01:07:22Z")
You could have a list of rows that have dates on them, and then set up a filter to show content whenever it’s within a certain number of days from today. ---
**Author:** ![Sage\_Edutitrof](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sage_edutitrof/32/28772_2.png) [@Sage\_Edutitrof](https://community.glideapps.com/u/Sage_Edutitrof)\ **Post date:** [July 14, 2021, 1:36am UTC](https://community.glideapps.com/t/triggers-or-auto-updated-information-on-user-end/29059/3 "2021-07-14T01:36:18Z")
Thank you @Jeff_Hager, I try it. But, it would be at least 180 days. 😀 ---
**Author:** ![Sage\_Edutitrof](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sage_edutitrof/32/28772_2.png) [@Sage\_Edutitrof](https://community.glideapps.com/u/Sage_Edutitrof)\ **Post date:** [July 14, 2021, 4:05pm UTC](https://community.glideapps.com/t/triggers-or-auto-updated-information-on-user-end/29059/4 "2021-07-14T16:05:21Z")
It worked. I learned to use a Unique formula with a Sort and Array formula. Crazy! But, awesome. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 14, 2021, 4:12pm UTC](https://community.glideapps.com/t/triggers-or-auto-updated-information-on-user-end/29059/5 "2021-07-14T16:12:26Z")
um, you could have done that with one or two Glide [computed columns](https://docs.glideapps.com/all/reference/data-editor/computed-columns)… ---
**Author:** ![Sage\_Edutitrof](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sage_edutitrof/32/28772_2.png) [@Sage\_Edutitrof](https://community.glideapps.com/u/Sage_Edutitrof)\ **Post date:** [July 14, 2021, 4:14pm UTC](https://community.glideapps.com/t/triggers-or-auto-updated-information-on-user-end/29059/6 "2021-07-14T16:14:28Z")
I’m a newbie, but willing to learning if you want to share specifics. I will also read the information from the link. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 14, 2021, 4:29pm UTC](https://community.glideapps.com/t/triggers-or-auto-updated-information-on-user-end/29059/7 "2021-07-14T16:29:43Z")
Well, just as an example, let’s say each announcement has an “Active At” date, and you only want to show announcements where the “Active Date” is after “now”, but no more than 2 days from “now”. So basically a 2 day rolling window. - Create a [Math column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/math-column), call it `mth/2-days-from-now`, the formula will be `Now + 2`, where `Now` is replaced with the current date/time. This gives you the date/time 2 days in the future. - Now create an [if-then-else](https://docs.glideapps.com/all/reference/data-editor/computed-columns/if-then-else) column: - If “Active At” is before Now, then empty (ignore dates in the past) - Else if “Active At” is after `mth/2-days-from-now`, then empty (ignore dates more than 2 days in the future) - Else `true` (anything that makes it this far is a keeper) This will give you a boolean column, where only those rows where the “Active At” date falls within the rolling 2 day window will be `true`. And you can use that boolean column as a filter. As a general rule, it’s better to do this sort of stuff in Glide (as opposed to using spreadsheet formulas) wherever possible, as you eliminate any delays caused by data syncing between Glide/Google Sheets/User Devices, and your app will be much “snappier”. This is because with Glide computed columns the computations _always_ take place on each users device, so results are instant. If you’re new to Glide, this is an important fundamental concept to get your head around.