Locking a Ticket

[dailo]

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.

[CobaltSky]

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. :(