Lock the doc so only designated user(s) can modify one field

You can make a button that will modify a row and set the “Approved” status to true, then you can make that button disabled if User().In(@User1, @User2,...).Not(). Then obviously hide the checkbox column and lock the section.

Also in that button’s label you can use a formula to show that it’s already approved, e.g.

IF(
  thisRow.Approved,
  "✔️ Approved",
  "Approve"
)

and add the OR thisRow.Approved = false to the “disable if” clause along with the user whitelist condition.

1 Like