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

Examples

("Admin" = USERROLE()) : Only designated app admins. See also USERROLE().

IN(USEREMAIL(), LIST("[email protected]", "[email protected]")) : Only specific users. See also: LIST(), USEREMAIL().

NOT(IN([Employee ID], Employees[Employee ID])) : Only for a new row, but not an existing row. See also: IN(), NOT().

(NOW() < ([Timestamp] + "024:00:00")) : Only if the row is less than a day old. See also NOW().

AND((TIMENOW() >= "08:00:00"), (TIMENOW() < "18:00:00")) : Only during business hours. See also: AND(), TIMENOW().

(WEEKDAY(TODAY()) = 2) : Only on Mondays. See also: TODAY(), WEEKDAY().

Did this answer your question?