How to clear an entire table?

Hi all,

Is there a Data command to clear (empty) an entire table? The table in question has three values: Row ID, A and B

(if there is one I missed it. I dabbled with Remove all elements with no success)

A pointer would be appreciated!

Do you need to clear the table once only as the builder of the app ? Or do you need the users of the app to clear the table ? If the latter (the users), do they trigger clearing the table or is this process triggered at regular intervals or on certain days?

“as the builder of the app”

Then select with your mouse/trackpad the cells you want to delete, hit “Delete” or “Backspace”, and confirm.

What about the users triggering clearing the table? (sorry about all the questions)

I’ve never had to do it, but I would explore setting up a workflow with a “Delete row” action and a loop.

thank you, @nathanaelb

If you need to delete the rows, create a query targetting the whole table without any filters, and delete all rows through that query.

Please note that this costs updates.

Is there also a watchout with user specific columns? If you delete the contents as one signed in-user of the App, the result will not delete the contents for all users…

1 Like

Yeah, we need to know the context better here to know if delete rows or set columns is the one to use, or if there’s anything fit for the use case at all.

Thank you. Good to know.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.