# Erasing a row when date is due **URL:** \ **Category:** Ask for Help\ **Created:** [November 11, 2021, 2:09pm UTC](https://community.glideapps.com/t/erasing-a-row-when-date-is-due/34396 "2021-11-11T14:09:45Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![merijn\_uijthoven](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/merijn_uijthoven/32/21943_2.png) [@merijn\_uijthoven](https://community.glideapps.com/u/merijn_uijthoven)\ **Post date:** [November 11, 2021, 2:09pm UTC](https://community.glideapps.com/t/erasing-a-row-when-date-is-due/34396/1 "2021-11-11T14:09:45Z")
Hi community! I am struggeling with the following: We are currently running a webapp with events linked to a certain date (e.g. 10th of november = 11/10). When the next day comes, we manually have to remove this date to make sure this particular event isnt shown in the app. Is there way that this particular cell (= date) is removed automatically when it’s for example 11th of November, to make sure this event isnt shown in the app anymore? ---
**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:** [November 11, 2021, 2:12pm UTC](https://community.glideapps.com/t/erasing-a-row-when-date-is-due/34396/2 "2021-11-11T14:12:35Z")
You can’t delete a row automatically using just Glide, but it’s easy enough to create a date based [filter](https://docs.glideapps.com/all/reference/design-and-structure/filter) to hide older entries from view. To auto-delete old rows, you need to use something external to Glide such as Apps Script or Integromat/Zapier. ---
**Author:** ![merijn\_uijthoven](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/merijn_uijthoven/32/21943_2.png) [@merijn\_uijthoven](https://community.glideapps.com/u/merijn_uijthoven)\ **Post date:** [November 11, 2021, 2:17pm UTC](https://community.glideapps.com/t/erasing-a-row-when-date-is-due/34396/3 "2021-11-11T14:17:44Z")
ok, thanks! And do you know if such an external program can autodelete rows connected to the real date? for example when its the next day, it automatically deletes the row prior the current date? ---
**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:** [November 11, 2021, 2:18pm UTC](https://community.glideapps.com/t/erasing-a-row-when-date-is-due/34396/4 "2021-11-11T14:18:57Z")
Yes, that’s possible. If you did it with Apps Script, then you’d just use a time-based trigger, or with Integromat then it’d be a scheduled scenario. ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 11, 2021, 2:38pm UTC](https://community.glideapps.com/t/erasing-a-row-when-date-is-due/34396/5 "2021-11-11T14:38:57Z")
I dont understand clearly if you are in need to remove the evidence from glide or from another web application. in case it is just glide then you dont need to delete anything. what you can do is act with a filter, you just set the filter to do not show the past date. in case you need to remove a value (the cell date), an option is that you do not refer directly to the cell date but to a field IFTHENELSE that in case of past date do not show it anymore, or otherwise creating a script on Googlescript (if you are using Googlesheet) to remove the date. ---
**Author:** ![merijn\_uijthoven](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/merijn_uijthoven/32/21943_2.png) [@merijn\_uijthoven](https://community.glideapps.com/u/merijn_uijthoven)\ **Post date:** [November 11, 2021, 3:28pm UTC](https://community.glideapps.com/t/erasing-a-row-when-date-is-due/34396/6 "2021-11-11T15:28:22Z")
thanks I got it, simply the filter “do not show past date” was perfect. thanks again! ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 11, 2021, 8:02pm UTC](https://community.glideapps.com/t/erasing-a-row-when-date-is-due/34396/7 "2021-11-11T20:02:05Z")
Welcome ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [November 12, 2021, 8:02pm UTC](https://community.glideapps.com/t/erasing-a-row-when-date-is-due/34396/8 "2021-11-12T20:02:56Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.