Column Insertable property

Previous Next

This is where you can specify that insertion of data in a column during a duplicate-record action is to be prevented.

If Column Insertable is set to No for a column:

On inserting a new record, this column will have read-only appearance: the user cannot enter data in the field. Nor is it possible to enter data in another way, for instance using a set-values() action, or by duplicating a record.

If the record is stored, you are no longer inserting, but updating: you can now enter data in columns that were set non-insertable.

NOTE: The exact behavior of the column depends on the combination of settings for Insertable, Updatable and Input Allowed.