Hi,

I have a filemaker database that keeps track of tickets for IT requests. I was wondering how I could change it so that once a ticket is closed, it makes the ticket no longer editable. Thanks.

Hello dailo,

One way to do this would be to use privilege set constraints. Eg if you set up record level access privileges for all users with a formula for editing records in the table in question (ie File-Define-Accounts & Privileges...-Privilege Sets-[PrivilegeSetName]-Records-CustomPrivileges...-[TableName]-Edit-Limited...) with a formula along the lines of:

not (TicketsTable::TicketStatus = "Closed")

When this is in place, users who log in with accounts which are assigned to the relevant privilege set/s will not be able to edit records in the TicketsTable table which have the value of 'Closed' in the TicketStatus field. :(