I created a button which executes DeleteRows() for a specific table.
When I click the button it says “This table does not allow deleting rows”
I am the owner of the document. The document is unlocked.
What else do I need to do in order to permit this?
Bumping this up - any thoughts?
How can I create a formula to delete all rows in a given table?
Unless I’m aware of anything new, this error is for when you’re trying to delete rows from a sync table. You cannot do this because the rows are mandated by the pack (i.e. it’s up to the pack to add or remove rows) and to have them deleted, you have to delete them in their source and then refresh your sync table so that it has updated data.
Indeed I am using it in a table created by your Formula Tables pack.
I have created additional AI columns in that table. The AI columns do not refresh when a query parameter change causes the formula columns to change.
Do I need to define the AI columns as part of the formula tables? That would mean that anyone who copies my document as a template would similarly need to edit the formula. I think there are a lot more users comfortable with adding columns than with editing a formula. Plus it’s easy to make a small error and break the formula when trying to add to it.