Clearing all cells in a column?

[Dave_Killeen]

Hi all

I’m trying to have a button clear the contents of all cells in a column. Is this possible?

Thanks!

[Dave_Killeen]

I figured it out. Thanks!

[Gregg_Stebben]

Hi, @Dave_Killeen…would you be willing to share what you figured out? This is something I could really use! Thank you!

[Scott_Collier-Weir]

Hey @Gregg_Stebben !

You can either do it as a canvas based button that uses the ModifyRows() function and changes all rows to blank “”.

Or you could make a column button that modifys thisRow.targetColumn —> “” and then a canvas button that presses the whole column.

The first option is better!

[Gregg_Stebben]

@Scott_Collier-Weir …that makes perfect sense, thank you!