Adding a custom table to a sys_user records related list

[Steven Parker]

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).

[Ashutosh Munot1 · 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.

[Steven Parker]

Once I added the reference field on my custom table referencing the User table, it worked perfectly.   Thank you for the explanation.

Now I just need to figure out how to add/remove items from this related list via a run script in a workflow.