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.
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() = "[email protected]").
("Admin" = USERROLE()) : Only designated app admins. See also USERROLE().
(NOW() < ([Timestamp] + "024:00:00")) : Only if the row is less than a day old. See also NOW().