How can I only show choices marked true?

[Andrew Meza]

To start this post off I do realize I should made both tables parent table the Task table, but I was a ServiceNow rookie and now I'm trying to make up for my past decisions. 

Here is the issue I am facing. I created custom fields for a Assignment Group. These two fields are "L4 Manager" and "Division.

For the "L4 Manager" this is linked to a custom table and columns are Name, Division, and Active. I got active from inheriting the task table.  When the assignment group fills in the "L4 Manager" custom field they are prompted all the L4 Managers with the active status. This works great.

The "Division" field in my head was going to also point to the "u_l4_manager" table but every time I select the field to fill it I am NOT prompted anything in the division field, I just see a duplicate name field and it list all the managers names. So, as a ServiceNow rookie I said, "I'll make another custom table" and I called it "u_l4_divisions" (task was NOT inherited this time). Once that was done, I pointed the division field to the new u_l4_division table and the L4 manager field to the u_l4_managers table. 

We had a shift in management and the team reached out to me saying I need to update the managers and their divisions. I made the changes on the u_l4_managers table and the team was thankful for the changes. They then went to the division field and saw no changes. Once I realized "Oh snap theres a completely other table that needs to be maintained also" I made the changes there but theres no active field. Once I made the changes now theres duplicated and I added a u_active field. 

Questions:

1.) Should I have gone about this a completely different way?

2.) Is there a way to implement a filter so when they select the "Division" field it does not show the inactive records?

3.) Instead of having a 2nd table, is there a way to have the Division field, show the Division but in the 1st table column "Division?

[Vishal Birajdar]

Hi @Andrew Meza 

You can configure the form, and get Division field from u_l4_managers table by dot-walking, so when manager gets changes automatically the division will be populated with there manager's division.

[Andrew Meza]

How exactly can I pull that off?

[Vishal Birajdar]

Hi @Andrew Meza 

This is your current scenario...(Please let me know if I'm wrong)

You need to implement it like below :

You can use below steps to get division field through dot walk: 

Step 1: Right click on Main form header & click on configure>> form layout

Step 2 : Click on "L4 manager" (+) icon & then expand it (Highlighted in red circle)

Step 3: You will get the fields from "L4 manager" table , Click on Division field and get it to right side of slush bucket

And Save it.

That's it...You will get the division field from Manager table on Main table

So now when you , update the manager automatically his/her division will be autopopulate.

So whenever managers division changes, you just need to update the Division of manager in L4 manager table.

Note : Table names & fields name will be different than yours.

Hope this helps...!!!