Determining create ACL to a table, based on the state of a parent table.

[sshah10]

Hi all,

I was wondering if somebody could help me solve this issue I am facing, when attempting to define a create ACL, for a child table, where create permissions need to be determined based on the state of a parent table, and the role assigned to a user.

Currently, records on the parent table have a related list linking to the child table, and depending on the state of the parent table and the users role, they would have the option to click 'new' to create new records on the child table using the related list. When the 'new' button is clicked, it opens a new form for the child table with the 'parent table reference field' auto populated. Unfortunately, however the create ACL is triggered before the 'parent table reference field' is auto populated and therefore, the ACL is unable to determent what the parent for the new record would be (i.e. current.parent_field = null, when acl is triggered).

If you have a solution for my problem I would really appreciate it, and feel free to ask if you need further clarification about my issue.

Thank you.

[Harsh Vardhan · Accepted solution]

another point i would like to mention here. if you are doing it on your custom table ( means both the table "parent" or "child" are custom table) then i believe you have one field that make a link between "parent" and "child". so in that case condition would be like 

ie: current.<field that reference to child table>.state == 4

if you are using in OOTB then ignore it.

adding one thread would also help you.

https://community.servicenow.com/community?id=community_question&sys_id=a5a88f21db5cdbc01dcaf3231f96...