SETLOCK

Lock a data input column to prevent users from entering data.

Syntax

SETLOCK([columns], value)

Arguments

columns - array of data input columns or a single data input column that needs to be locked. Use with the COLUMNS keyword to select a particular column.

value - Boolean value used to control footer visibility. Set to TRUE to lock the data input field.

Example

SETLOCK([COLUMNS.[Central > Projection], COLUMNS.[Central > Tax]], TRUE)
//Locks the Projection and Tax data input columns under the 'Central' region.

Script to lock specific columns

Locking data input fields with scripts:

Locking data input columns using scripts