# Is it possible to automate the deletion of data in a column?
**URL:** https://community.glideapps.com/t/is-it-possible-to-automate-the-deletion-of-data-in-a-column/44283
**Category:** Ask for Help
**Created:** [July 11, 2022, 1:03pm UTC](https://community.glideapps.com/t/is-it-possible-to-automate-the-deletion-of-data-in-a-column/44283 "2022-07-11T13:03:53Z")
**Posts on this page:** 15
**Page:** 1
### Author:  [@Alexandre\_Cuny](https://community.glideapps.com/u/Alexandre_Cuny)
#### Post date: [July 11, 2022, 1:03pm UTC](https://community.glideapps.com/t/is-it-possible-to-automate-the-deletion-of-data-in-a-column/44283/1 "2022-07-11T13:03:53Z")
Hi everyone !
I’m new to Glide and I work for a non-profit association in France (I’m sorry if my english isn’t good). We propose activites like dancing, drawing, aerobics, etc.
I’m currently making an app that lets our members register each week for specific activities (the activites won’t change, and neither will the date and time). My question is: is there a way to automate the deletion of data in a column, so it can be reset for the following week ?
Thank you in advance for your help,
Alexandre Cuny
---
### Author:  [@Daniel\_Brassnyo](https://community.glideapps.com/u/Daniel_Brassnyo)
#### Post date: [July 11, 2022, 1:22pm UTC](https://community.glideapps.com/t/is-it-possible-to-automate-the-deletion-of-data-in-a-column/44283/2 "2022-07-11T13:22:14Z")
If I were u, I would rather automate creating new records (same activity with different dates) and set a content filter in Glide by ‘This week’ date.
---
### Author:  [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)
#### Post date: [July 11, 2022, 1:30pm UTC](https://community.glideapps.com/t/is-it-possible-to-automate-the-deletion-of-data-in-a-column/44283/3 "2022-07-11T13:30:52Z")
Maybe this thread will help here!
> [@Delete the data from a table of a dating application](https://community.glideapps.com/t/delete-the-data-from-a-table-of-a-dating-application/38993):
>
> hi, does anyone have an example of how to delete the data from a table of a dating application, for example, I have an appointment for the day 01/03/2022 In March at 2:00 p.m., how can that data be deleted? If the appointment has already passed that day, it is no longer necessary to have it on the sheet. How can it be deleted automatically? Thanks
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 12, 2022, 12:52am UTC](https://community.glideapps.com/t/is-it-possible-to-automate-the-deletion-of-data-in-a-column/44283/4 "2022-07-12T00:52:00Z")
Maybe we need to know better about your data structure here. How are you recording the “registration” of a user for an event? Is it a new row in another table or something else?
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [July 12, 2022, 6:43am UTC](https://community.glideapps.com/t/is-it-possible-to-automate-the-deletion-of-data-in-a-column/44283/5 "2022-07-12T06:43:26Z")
Bonjour Alexandre 👏
I’ll answer in English but feel free to switch over to French.
**Automatically deleting data from a table**
- No, you cannot automate the deletion of data in a Glide Table.
- No, you cannot automate the deletion of data from any table (Google Sheets for instance) _natively_ in Glide. You could write (or find) a script in AppScript in Google Sheets, but this would not be a native function in Glide and this would not be nocode. Basically, this can be done, but only outside the Glide ecosystem.
- Deleting data is an action. As of now, actions in Glide are triggered by a user, they cannot be time-triggered (for example “Perform this action daily at midnight”).
- See Jeff’s method in the thread shared above to _simulate_ automatic deletion, by having a user action perform the action you need without the user knowing (such as deleting data).
---
### Author:  [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [July 12, 2022, 7:06am UTC](https://community.glideapps.com/t/is-it-possible-to-automate-the-deletion-of-data-in-a-column/44283/6 "2022-07-12T07:06:35Z")
Curious. Does Glide offer a way for a signed in user to sign-out and be forgotten permanently. For example, their email address permanently deleted at the request of the user? What happens when the user opts to sign-out? Is their row in the users sheet deleted?
Just wondering if this is an example of a user triggered event that deletes data in a Glide Table. Albeit, not very useful in the context of this thread.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [July 12, 2022, 7:12am UTC](https://community.glideapps.com/t/is-it-possible-to-automate-the-deletion-of-data-in-a-column/44283/7 "2022-07-12T07:12:54Z")
No. The only way to do this would be via some external integration. And even then, any user specific data associated with that user would still be stored internally within Glide. And the only way to get rid of that is via the builder (Settings-\>Data-\>Delete User Data). It might eventually be purged when a User Profile row no longer exists, but I don’t know if that is the case or not, so I wouldn’t rely on it.
---
### Author:  [@Thibault](https://community.glideapps.com/u/Thibault)
#### Post date: [July 13, 2022, 12:26pm UTC](https://community.glideapps.com/t/is-it-possible-to-automate-the-deletion-of-data-in-a-column/44283/8 "2022-07-13T12:26:15Z")
Hi, you can use “sheet automation” add-on to automate task on your sheeet
---
### Author:  [@Alexandre\_Cuny](https://community.glideapps.com/u/Alexandre_Cuny)
#### Post date: [August 22, 2022, 9:37am UTC](https://community.glideapps.com/t/is-it-possible-to-automate-the-deletion-of-data-in-a-column/44283/9 "2022-08-22T09:37:58Z")
Hi, sorry for the late response. Yes, but automation would still be a problem.
---
### Author:  [@Alexandre\_Cuny](https://community.glideapps.com/u/Alexandre_Cuny)
#### Post date: [August 22, 2022, 9:39am UTC](https://community.glideapps.com/t/is-it-possible-to-automate-the-deletion-of-data-in-a-column/44283/10 "2022-08-22T09:39:08Z")
Sorry for the very late response… that would work, but it would mean that I’d have to manually input the date of every course in the entire year every time, which defeats the purpose (if I understood it well ?)
---
### Author:  [@Alexandre\_Cuny](https://community.glideapps.com/u/Alexandre_Cuny)
#### Post date: [August 22, 2022, 9:42am UTC](https://community.glideapps.com/t/is-it-possible-to-automate-the-deletion-of-data-in-a-column/44283/11 "2022-08-22T09:42:40Z")
Hi, sorry for the very late answer. Yes, the choices are stored in another table (currently a google sheet, to try and use Apps Script to automate it).
@nathanaelb Thank you for your suggestions ! Jeff’s method still needs someone to input a date every time the data needs to be reset (and I need to do it every week). It seems too hard to apply it to my case.
@Thibault Hi, I didn’t find the “sheet automation” add-on. Where can I find it ?
---
### Author:  [@Thibault](https://community.glideapps.com/u/Thibault)
#### Post date: [August 22, 2022, 10:10am UTC](https://community.glideapps.com/t/is-it-possible-to-automate-the-deletion-of-data-in-a-column/44283/12 "2022-08-22T10:10:01Z")
> **[Sheet Automation - Automate Google Sheets - Google Workspace Marketplace](https://workspace.google.com/marketplace/app/sheet_automation_automate_google_sheets/250108887537)**
>
> Automatic mail merge, data processing, task tracking, and many more.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 23, 2022, 12:07am UTC](https://community.glideapps.com/t/is-it-possible-to-automate-the-deletion-of-data-in-a-column/44283/13 "2022-08-23T00:07:10Z")
> [@Alexandre\_Cuny](#):
>
> to try and use Apps Script to automate it
If you need some help with this please tell us.
---
### Author:  [@Alexandre\_Cuny](https://community.glideapps.com/u/Alexandre_Cuny)
#### Post date: [August 23, 2022, 3:46pm UTC](https://community.glideapps.com/t/is-it-possible-to-automate-the-deletion-of-data-in-a-column/44283/14 "2022-08-23T15:46:35Z")
Hi, thanks ! Well, I prefered to use the glide tables to limit registration to the courses we propose. I tried to find a way to separate the data related to registration from the data related to the registration limit, but I couldn’t (I couldn’t keep all my data on my google sheet, because visibility conditions didn’t work with it). I’m still looking for a way to “automate” it, but I’m kinda short on ideas. All I wanted was for the courses to repeat each week, I didn’t think it would be that complicated, haha
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 23, 2022, 4:29pm UTC](https://community.glideapps.com/t/is-it-possible-to-automate-the-deletion-of-data-in-a-column/44283/15 "2022-08-23T16:29:54Z")
Regarding your issue with google sheets and visibility, I just posted a response to that thread.
> [@Visibility condition with numbers and AND with GDOCS isn't working](https://community.glideapps.com/t/visibility-condition-with-numbers-and-and-with-gdocs-isnt-working/47433/6):
>
> Something isn’t right and I can’t quite put my finger on it. I don’t see any reason why this shouldn’t work, but I think I’m still missing some details about how you have your screen and settings configured. So it’s apparent that you are using a form container. What I’m suspecting though, is that your visibility conditions are actually looking at values in the new row that hasn’t been submitted yet. It looks to me like your tab is pointing to the inscription table and your form is writing to…