How to restrict "Insert New Row" on embedded list based on certain condition
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-22-2020 06:34 AM
Hi All,
I have a requirement where I wanted to restrict "Insert new row" on an embedded list based on a condition.
So, if the Phase = "Implementation", I wanted to restrict the user to enter any record through the embedded list. I have tried restricting it using "Omit Insert row condition" but it's not working
Please refer below screenshot for the form details
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-22-2020 06:44 AM
Hi Ks,
You cannot do it directly with the list control option you have to do it with the help of aCLfor that.
This article will help you : as this is having same requirement.
Mark helpful and correct if it helps.
Thanks,
CB

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-22-2020 06:48 AM
Hi Try removing "answer" from line number 9.
OR try below
Securing Records in an Embedded List
To apply security to the records in embedded lists, limit editing and deleting records in embedded lists to specific roles.
- Navigate to System Security > Access Control.
- Open the Write or Delete record for the appropriate table.
- In the Requires Role section of the form add the roles that have write or delete permission for that table.
- Save the changes.
- When records from the associated table appear in an embedded list, the edit and delete options will be available only to users with the specified roles.
Regards,
Ajay
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-23-2020 01:21 AM
When I tried the create ACL with condition -- parent.phase is so and so -- as the parent field will hold the sys_id of parent table record,
1) It is not working for the first time creation of the record through embedded list (from parent form).
2) It is working if the parent has at least one child record in the embedded list. But with this scenario, it is impacting the users while they create first record through embedded list.
I also tried using the ACL script block but no luck :(.
Please advise if any body has any tips on this to take this forward?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-16-2024 09:20 AM
That field doesn't seem to be evaluated - at least not in a scoped app. What I do is create a sys_relationship with the same filter as the dot-walked OOB list. I find that that allows for more control, including removing the "insert new row" row.