topic Re: JSl Code to Delete Column Referenced By Formula in Discussions

JSl Code to Delete Column Referenced By Formula

terapin — Mon, 03 Jan 2011 16:52:50 GMT

I'm trying to delete a column in JSL. However, the column to be deleted is used by another column in a formula. I can't find the syntax for JSL to remove the formula when I delete the column. Any ideas how to accomplish this would be appreciated.

Re: JSl Code to Delete Column Referenced By Formula

Anonymous — Wed, 07 Mar 2018 14:08:49 GMT

You should delete the formula referencing the column first:

Column("column name") << delete formula;

Then delete the column.

Re: JSl Code to Delete Column Referenced By Formula

terapin — Wed, 05 Jan 2011 15:40:09 GMT

Thanks. That was rather simple and easy.