Subscribe Bookmark RSS Feed

JSl Code to Delete Column Referenced By Formula

terapin

Community Trekker

Joined:

Jun 23, 2011

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.
1 ACCEPTED SOLUTION

Accepted Solutions
thechadd

Community Trekker

Joined:

Jun 23, 2011

Solution
You should delete the formula referencing the column first:

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

Then delete the column.
2 REPLIES
thechadd

Community Trekker

Joined:

Jun 23, 2011

Solution
You should delete the formula referencing the column first:

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

Then delete the column.
terapin

Community Trekker

Joined:

Jun 23, 2011

Thanks. That was rather simple and easy.