cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
TannazTaj
Level I

Lock the formula in a column

I am working on a standard data table with saved formulas in some columns. I know when you have a formula in a column, the data entry would be locked but is there any option to also lock the formula so the users cannot change the formula without for example having a password? Thanks for your answers in advance 

1 REPLY 1
Byron_JMP
Staff

Re: Lock the formula in a column

I'm not sure how to do that, but you could evaluate the formula, then delete it then lock the column.

 

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << new column("Ratio", formula(:height/:weight));
:Ratio<<delete formula;
:Ratio << Lock( 1 );

...then in the SOP that governs data analysis say,  if(caught editing formulas | caught editing data=1,"Fired")

JMP Systems Engineer, Health and Life Sciences (Pharma)