Change event field from work to standby

[DullaB]

Under Shift Planning we have Agent Schedule.

Double-click the row field called Work in the Event column against the filtered schedule entry

Modify the Type field by selecting Standby from the dropdown menu  replaces "Work" type).

How can we achieve this scenario using acl. I have created table and field level write acl permission but it's edited all the fields I the work record I need to edit only event field that to work record to standby can you guys suggest methe better approach 

[Vikram Reddy]

Hey @DullaB,

sn_shift_planning_event.type            write ACL -> role: shift_editor (allow)
sn_shift_planning_event (no field, table level)  write ACL -> role: shift_editor (allow)
sn_shift_planning_event.start_date      write ACL -> role: admin (blocks shift_editor)
sn_shift_planning_event.duration        write ACL -> role: admin (blocks shift_editor)
sn_shift_planning_event.event_category  write ACL -> role: admin (blocks shift_editor)

A field ACL can only narrow what the table-level write ACL already allows, it can never grant more. So the moment your table-level write ACL lets that role save the sn_shift_planning_event record at all, every field without its own field ACL just inherits that same write access, which is why locking down "type" alone did nothing. Keep the table-level write ACL (you need it to save the record in the first place), then add an explicit write ACL on every other field that excludes your role, leaving only type open.

Thank you,
Vikram Karety
Octigo Solutions INC