Examples: Section access formulas
- This formula restricts edit access to a section to Mary Chen and Donna Hill.
"Mary Chen" : "Donna Hill"
- 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)
- This formula restricts edit access to the section to those users assigned the [EditStaff] role in the ACL.
"[EditStaff]"
- 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-")