# Erase all previous data

**URL:** <https://community.glideapps.com/t/erase-all-previous-data/18590>\
**Category:** Ask for Help\
**Created:** [November 18, 2020, 1:34am UTC](https://community.glideapps.com/t/erase-all-previous-data/18590 "2020-11-18T01:34:44Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**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 19, 2020, 6:42am UTC](https://community.glideapps.com/t/erase-all-previous-data/18590/8 "2020-11-19T06:42:39Z")

</div>

> [@Todd\_Lichtenwalter](#):
>
> Thank you Darren, that is a very useful tip, yet in this case I want the students to be able to fire this change right then and there without my intervention. Could I use your technique for this? Like maybe have a toggle switch and every time the toggle changes it erases all the rows in the sheet containing that users email?

Doing it for one row is easy, and can appear instant by using filter conditions to hide the row once it’s flagged.

Doing it for all rows belonging to the same user is a little trickier, but I believe it should be possible. I’m thinking that you’d need to use some combination of user specific columns with some funky rollup/ITE columns such that if one row gets flagged, then they all get flagged (and hidden). I can’t immediately think how to do this, but I “feel” like it should be possible. @ThinhDinh @Jeff_Hager any ideas?

Edit: Actually, you may be able to adapt the technique that @Robert_Petitto demonstrates in [this](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555) post.

---

_[View the full topic](https://community.glideapps.com/t/erase-all-previous-data/18590)._