Is it possible to make a "List" field dependent on a "Choice" field?

[C_dric Chen]

Hello, people.

Long story short, a business requirement in an app that I'm developing calls for a "List" (multiple-choice) field (let's call is "u_depend") whose available options depend on the value in a different "Choice" field (let's call it "u_dictate"). Below is an over-simplified explanation:

• Available choices in "u_dictat": A, B, C, D. The choices are configured.
• Available choices in "u_depend": Elephant, lion, tiger, panther, wolf, dog, cat, mouse. The choices comes from a separate table in the same scope.

• When "u_dictate" == A, the available choices in "u_depend" are: Elephant, lion, tiger.

• When "u_dictate" == B, the available choices in "u_depend" are: Lion, tiger, panther. (Yes, there are lots of overlaps in the actual business requirement.)

• When "u_dictate" == C, the available choices in "u_depend" are: Wolf, dog, mouse.

• When "u_dictate" == D, the available choices in "u_depend" are: Cat, mouse.

Would anyone like to kindly point me at the right direction of fulfilling this requirement?

Thank you in advance!

[SN_Learn]

Hi @C_dric Chen ,

You can call a script include in the advance reference qualifier of your list field and pass the value of your choice field as parameter.

In the Script include you will glide record to your u_dependent table and return the required record.

Please take a look:

https://www.servicenow.com/community/itsm-articles/dynamic-reference-field-values-based-on-select-bo... 

[C_dric Chen]

Hello. I examined your article and I found out that "getEnvVal" seems to be a function defined outside the scope of the app. What if I need to look up something in a different table in the same scope?