cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
FN
FN
Level VI

Locking column so the user is unable to delete or change its column name

Is there a simple way to lock a specific column in a data table, so users cannot delete or change its name by mistake?

 

This column is used as time index (UTC).

1 ACCEPTED SOLUTION

Accepted Solutions
SDF1
Super User

Re: Locking column so the user is unable to delete or change its column name

Hi @FN ,

 

  I know that you can definitely lock a column in the Column Info screen. This will lock the entries in the column to prevent any from being modified, but it doesn't stop the name from being changed. What about hiding (and/or excluding) the column? This could work if users don't really need to see it, but the column is needed for other formulas or something.

 

  If it's a matter of scripting and using the column name, you could get around that by putting the column as the first column in the data table and then hide it. In the JSL code, you could reference the column by number (1), that way if they happen to change the name, the JSL code would still work. Not ideal, but doable.

 

Good luck!,

DS

View solution in original post

1 REPLY 1
SDF1
Super User

Re: Locking column so the user is unable to delete or change its column name

Hi @FN ,

 

  I know that you can definitely lock a column in the Column Info screen. This will lock the entries in the column to prevent any from being modified, but it doesn't stop the name from being changed. What about hiding (and/or excluding) the column? This could work if users don't really need to see it, but the column is needed for other formulas or something.

 

  If it's a matter of scripting and using the column name, you could get around that by putting the column as the first column in the data table and then hide it. In the JSL code, you could reference the column by number (1), that way if they happen to change the name, the JSL code would still work. Not ideal, but doable.

 

Good luck!,

DS