# How to delete whole column at set time

**URL:** <https://community.thunkable.com/t/how-to-delete-whole-column-at-set-time/612974>\
**Category:** Questions about Thunkable X\
**Created:** [June 13, 2020, 12:40pm UTC](https://community.thunkable.com/t/how-to-delete-whole-column-at-set-time/612974 "2020-06-13T12:40:23Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![kizzy](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kizzy/32/76421_2.png) [@kizzy](https://community.thunkable.com/u/kizzy)\
**Post date:** [June 13, 2020, 12:40pm UTC](https://community.thunkable.com/t/how-to-delete-whole-column-at-set-time/612974/1 "2020-06-13T12:40:23Z")

</div>

How to delete whole column at 12:01 am every day to start again in data list view?  
any help with block plz

---

<div class="post-metadata">

**Author:** ![bobsunscreen](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bobsunscreen/32/85667_2.png) [@bobsunscreen](https://community.thunkable.com/u/bobsunscreen)\
**Post date:** [June 13, 2020, 12:56pm UTC](https://community.thunkable.com/t/how-to-delete-whole-column-at-set-time/612974/2 "2020-06-13T12:56:09Z")

</div>

Whenever a user opens your app, you can use a “current hour” and a “current minute” block to read the time and then save it. You can then read the last time the user opened your app, and the time the user currently has your app open. You can then use an “if” block to see whether it has already passed 12:01. If the past time was before 12:01 and the current time is after 12:01, and if the list still has information saved to it, code the list to delete that info. If not, the information stays in the list.

---

<div class="post-metadata">

**Author:** ![kizzy](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kizzy/32/76421_2.png) [@kizzy](https://community.thunkable.com/u/kizzy)\
**Post date:** [June 13, 2020, 1:01pm UTC](https://community.thunkable.com/t/how-to-delete-whole-column-at-set-time/612974/3 "2020-06-13T13:01:41Z")

</div>

um no i want to use the list as a sort of APP counter  
People click button it make an entry on the list at a particular name & time  
but i want this to repeat every day so that data has to cleared to start over again.

---

<div class="post-metadata">

**Author:** ![bobsunscreen](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bobsunscreen/32/85667_2.png) [@bobsunscreen](https://community.thunkable.com/u/bobsunscreen)\
**Post date:** [June 13, 2020, 1:05pm UTC](https://community.thunkable.com/t/how-to-delete-whole-column-at-set-time/612974/4 "2020-06-13T13:05:04Z")

</div>

What I have described accomplishes that exact goal. Code the app to do this: Look to see if the previous entry was before 12:01. If the current time is after 12:01, then clear the list.

---

<div class="post-metadata">

**Author:** ![kizzy](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kizzy/32/76421_2.png) [@kizzy](https://community.thunkable.com/u/kizzy)\
**Post date:** [June 13, 2020, 1:25pm UTC](https://community.thunkable.com/t/how-to-delete-whole-column-at-set-time/612974/5 "2020-06-13T13:25:26Z")

</div>

but i want entries made after 12:01 but in the new day

---

<div class="post-metadata">

**Author:** ![bobsunscreen](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bobsunscreen/32/85667_2.png) [@bobsunscreen](https://community.thunkable.com/u/bobsunscreen)\
**Post date:** [June 13, 2020, 1:30pm UTC](https://community.thunkable.com/t/how-to-delete-whole-column-at-set-time/612974/6 "2020-06-13T13:30:05Z")

</div>

I don’t understand. I thought you wanted your list to be deleted and start over at 12:01?

---

<div class="post-metadata">

**Author:** ![kizzy](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kizzy/32/76421_2.png) [@kizzy](https://community.thunkable.com/u/kizzy)\
**Post date:** [June 13, 2020, 1:32pm UTC](https://community.thunkable.com/t/how-to-delete-whole-column-at-set-time/612974/7 "2020-06-13T13:32:41Z")

</div>

yes start new day that why i want to clear column once at that time think i can get a block with current time

---

<div class="post-metadata">

**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\
**Post date:** [November 8, 2024, 11:27am UTC](https://community.thunkable.com/t/how-to-delete-whole-column-at-set-time/612974/8 "2024-11-08T11:27:08Z")

</div>


