I have one table called 'Issues' and has many fields, like a field called 'assigned_to' having a 're
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2024 02:12 AM
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'
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2024 02:16 AM
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]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2024 02:24 AM
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.
Thanks
Anil Lande
