What do you think about a method tonot clear a complete global table but only one/some rows or columns. Actually I´m allways doing this with for Loops.
Clear rows or columns of a global table
Agreed, something along the lines of Table.clearCol(3) to clear a specific column; plus an option to pass an array like Table.clearCol([3,5,6]) to clear a few columns with a single command.
Table.query("UPDATE GlobalTable1 SET [Col 1]=0,[Col 3]=''")
I think it would be great if one could clear a certain row or column with the clear command, e.g. using optional parameters like Table.clear(row or column, row/column number). The loop solution obviously works, but allowing the user to clear the whole row or column with one command would be more user friendly.
Axel
@Ben Wilson I think what sebastian is suggesting is basically an addition to Table.deleteRow. Currently, you can use Table.clear to remove all values from a table, or Table.deleteRow to delete a specific row. Deleting multiple rows, but not all requires a for loop to delete each row specifically. It would be helpful if you could use Table.deleteRow(startingRow, EndRow) where it will delete all the rows within the range specified.
5 People are following this idea.