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

FN — Fri, 09 Jun 2023 22:10:29 GMT

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).

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

SDF1 — Tue, 06 Apr 2021 15:02:24 GMT

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!,

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

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

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