I have one table called 'Issues' and has many fields, like a field called 'assigned_to' having a 're

Abhishek Kathe
Mega Guru

I have one table called 'Issues' and has many fields, like a field called 'assigned_to' having a 'reference' field type which refers to the 'sys_user' table. I want to give edit access of this table records to only currently logged in users who are present in the 'assigned_to' filed, other people should not edit the record except 'admin' 

2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Abhishek Kathe 

 

Access to table or Table records?

 

I assume it is table records. 

 

You can achieve this via Business Rule.

 

If current.user ISMemebe of assignement.group(sys_id group )

Field Editable

else

Set. form field readonly. 

 

I am not expert in code, but the base line is this. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Anil Lande
Kilo Patron

Hi,

You can modify the 'Write' ACL for your table.

In Write ACL add condition "Assigned to IS Dynamic Me" along with basic role required to read and write.

Make sure no other Table ACL is passed for other users for Write permission.

 

 

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande