The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Adding a custom table to a sys_user records related list

Steven Parker
Giga Sage

So we have a custom table for our Applications and I wanted to add a Related List on a user record showing the various "Application Access" that user had.

I know there is a skills table on the user record, but I wanted to see if we could reference our current Application List table somehow.   I don't see it when I click the hamburger icon and click related list as it appears it only shows reference fields as choices there and our list has no reference fields.

How can I add my custom table to the highlighted area below, as "Application Access", so we can pick applications from our current custom list to show on a user record?   Really only need to see the Application name from our list in this related list (and maybe the date added).

find_real_file.png


Please mark this response as correct and/or helpful if it assisted you with your question.
Steven
1 ACCEPTED SOLUTION

HI Steven,



So how it works is like this.


Example: If you want to add related list to USER table then you will have to create a reference field on your custom table which will refer to sys_user table.



So OOB relationship will be created by service now and you will directly see a option in related list section when you configure them.




In that you will   get both New and Edit options. This will be One to Many relationship. One user related to number of applications



Thank you,


Ashutosh Munot



Please Mark it as helpful or Correct. You can endorse this as well.


View solution in original post

11 REPLIES 11

Ashutosh Munot1
Kilo Patron
Kilo Patron

HI Steven,



You have to create relationships for this.



https://www.servicenowguru.com/system-definition/relationships/defined-related-lists/



Thank You,




Ashutosh


If I make user of relationships, which I did....how can I make it where I can click Edit and select an app instead of clicking "New"...Because when I click "New", I don't have the option of choosing an existing application to add to the list.   I don't want to add a new application name into the table, I just want to add current existing apps in this related list for each user.



find_real_file.png



Please mark this response as correct and/or helpful if it assisted you with your question.
Steven

Please update list control of your related list to allow edit roles for your related list.




find_real_file.png



Regards,


Sachin


I wish that worked...added Admin role and nothing.   "Omit Edit Button" is not checked and "Enable Edit" button does nothing.



Please mark this response as correct and/or helpful if it assisted you with your question.
Steven