I am trying to have daily overnight reset of all values in my cells of data blaze. I want to keep my table and the name of the columns but all the data insides cell will be permanently removed. Is there a way?
Hi Robert,
There isn't a way to do this overnight automatically in Data Blaze yet, but you can create a Text Blaze snippet that you trigger each morning to achieve this. I created an example below that you can connect to your own Data Blaze space, but I recommend using this snippet with caution since it will delete all the rows in your table. I added a toggle so you have to confirm that you want to delete the data.
{dbselect: SELECT rowid() AS Row ID FROM Demo Test; space=0PACCKy4UYB3ADWT8maG8l; menu=no; multiple=yes}
{formtoggle: name=Confirm Delete; default=no}{repeat: for row in {=row id}}{dbdelete: DELETE FROM Demo Test WHERE rowid() = {=row}; space=0PACCKy4UYB3ADWT8maG8l}{endrepeat}{endformtoggle}
Hi Robert,
We don't recommend deleting using dbselect commands as I showed above, as it has the possibility of mistakes and may hit rate limits. We want to add an easy way to delete all rows in the future, but for now simplest way to do it would be manually or the token API (which would require programming).
Thank you so much! I understand the risk! It will be a nice feature in the future!
I try your suggestion and I change the name of the table which is lab for me and added a count then hide it in the table. The snippet reads the count as a list. It is working as I wanted! Thanks again!
{dbselect: SELECT Count FROM lab; space=0jdwXRpvcJG9qZr5UnGhnD; menu=no; multiple=yes}
{formtoggle: name=Confirm Delete; default=no}{if: `confirm delete`}{repeat: for item in count}{dbdelete: DELETE FROM lab WHERE Count = @item; space=0jdwXRpvcJG9qZr5UnGhnD}
{endrepeat}{endif}