- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-28-2011 09:21 AM
I am trying to set up an embedded list and use the "Omit Insert Row Condition" property. I have tried but cannot figure out what kind of condition I need to set up so that it will work properly. What I am trying to do is whenever the state on our Story form is Closed Complete or Closed Incomplete, I do not want the Insert Row to be available. I have tried calling a function that returns a value of true when those conditions are met, setting the variable "answer" to true, and even simply typing 'return = true;' with no success. I cannot find any documentation for this on the Wiki or the forums either... Hoping someone here has done this and can help!!
Thanks,
Mike
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-27-2011 08:00 PM
Finally got it to work:
I managed to do everything using ACLs:
1) create: create a script or add roles. do NOT use reference fields at this time, because they will not be populated if there is no embedded record yet
2) write: this is the rule that determines who can write OR CREATE a record. If people have create roles but no write, then they cannot write to the "new" record, hence they cannot actually save the new record and no new record will be created. This means that the create may be less restrictive than the write rule.
3) delete: (optional) if you want users to be able to delete, set this ACL.
4) list_edit: don't forget to set this one, especially if you have removed these rights to prevent little accidents.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-27-2011 08:00 PM
Finally got it to work:
I managed to do everything using ACLs:
1) create: create a script or add roles. do NOT use reference fields at this time, because they will not be populated if there is no embedded record yet
2) write: this is the rule that determines who can write OR CREATE a record. If people have create roles but no write, then they cannot write to the "new" record, hence they cannot actually save the new record and no new record will be created. This means that the create may be less restrictive than the write rule.
3) delete: (optional) if you want users to be able to delete, set this ACL.
4) list_edit: don't forget to set this one, especially if you have removed these rights to prevent little accidents.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-28-2011 05:40 AM
Thanks martijn!
I ended up using the related lists instead of the embedded lists. Turns out there was functionality added in the June release that gave related lists the same "on-the-fly" record adding that we were looking for from embedded lists and we didn't even realize it was there!
I figure we will just wait for the embedded list stuff to be fixed by SNC before we try implementing it again...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-01-2015 11:06 AM
Worthy to note that I wanted the other way round, I wanted to add an embedded list and the insert row button/field was not there. The workaround I did was to add the list as related list first, personalize and enable the list insert row, remove the related list from the form, then add it again from the form layout instead.
Hope this helps someone some day, took a lot of time from me.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-23-2015 02:57 AM
Adding as a related List then removing and adding again worked great.
However, how do I ensure the records do not show each time? So for example I have added this to my Change Form to display Firewall information. Users can edit the list and add the information then save. However, each time a New Change is opened it always shows everything that is in that table. Any ideas?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-28-2015 08:56 AM
Hi Mike,
I have run into the same issue today. Have you ever managed to get "Omit Insert Row Condition" script working for an Embedded List? If not, did you report the issue to ServiceNow Technical Support? Thanks.
Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/