Examples: Section access formulas

  1. This formula restricts edit access to a section to Mary Chen and Donna Hill.
    "Mary Chen" : "Donna Hill"
  2. This formula restricts edit access to the section to those users listed in Column 1 of the By Person view of the current database.
    @DbColumn(""; ""; "By Person"; 1)
  3. This formula restricts edit access to the section to those users assigned the [EditStaff] role in the ACL.
    "[EditStaff]"

  4. This formula defines who can edit the section based on the content of the Status field on the form. If Status contains "Submitted," users with [Editors] or [Admins] user roles in the ACL can edit it. If Status contains "Draft," only the user whose name is in the OriginalAuthor field can edit it. Otherwise, noone can and "-nobody-" displays in the "Who can edit this section" dialog box if a user attempts to edit it.
    @If(Status = "Submitted"; "[Editors]":"[Admins]"; Status = "Draft"; OriginalAuthor; "-nobody-")