New to expressions and formulas? Try Expressions: The Essentials.

New to column constraints? Try Column Constraints.

You can also learn more about other types of expressions.

Expressions in this article align with the Yes/No Expressions in Expression Builder in the app editor.

When an input column is "editable", it can be modified by the user. The Editable_If column constraint is useful to lock down a column (to prevent user edits) depending on the value already in the column or on the values of other columns.

An Editable_If constraint is a condition expression that indicates if a specific column is "editable" in an input form. For instance, ISBLANK([_THIS]) allows edits only if the current value is blank, but once there is a value, the field cannot be edited. Another common use case is to give certain users the ability to edit a field, but make it read-only for others (e.g. USEREMAIL() = "manager@acme.com").

Did this answer your question?