AnsweredAssumed Answered

Locked myself out

Question asked by DanielShanahan on Jul 31, 2013
Latest reply on Aug 2, 2013 by jormond

One of my tables is a JOB table and I want the ability to for the office staff to manual lock a record. This usually happens after a job has been scheduled and the customer has been called. This works great except for one small problem - I can't unlock it! I've painted myself into a corner.

 

I have a privilege set named "Admin" and the Records are "Customized privileges..."

 

JOB table, in the Edit column is "limited...", defined as appointmentStatus="Unlocked"

 

JOB::appointmentStatus field is a pull-down field and I've attached a script trigger OnObjectModify that changes "Locked" to "Unlocked" and runs with Full Access privileges (the problem doesn't occur with Full Access). However, the script never runs; I get the message that my privileges do not allow this action.

 

Any ideas how I can change the JOB::appointmentStatus within this privilege set?

 

Thanks.

Outcomes