We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Field dependency between Two fields in Incident form

chaithanya gund
Tera Contributor

Hi Team,

 

I have two fields in Incident Form 1. Sub Category (Which is Choice List ) and Service Offering field ( which is a Reference field to Service_offering table where 44 choices are present). 

 

My Requirement is when a Particular Sub category is selected for Ex: Hardware then only Service Offerings related to Hardware should be visible in the Lookup of Service Offering (Ex: 4 Service Offering are related to Hardware) and remaining 40 Choices in table shouldn't be Visible. And in the same way Sub category is selected for Ex: Software then only Service Offerings related to Software should only be visible in the Lookup of Service Offering and other choices should be hidden.

 

How can i Achieve this requirement. Request you to provide your Suggestions.

 

Thank You!

1 ACCEPTED SOLUTION

Dr Atul G- LNG
Tera Patron

Hi @chaithanya gund 

 

I had a similar use case a few days back, and here’s the approach we used. It’s not very difficult, but I’ll highlight the steps:


Steps Used:

  1. Create BS and SO

    • Establish relationships between them.

  2. Create Category and Sub-Category

    • Use the System Choice Table for this.

  3. Dependency Between BS and SO

    • To manage this, the best approach is to use a User ID Decision Table.

    • Reason: It’s easy to maintain, especially if you plan to add more categories or sub-categories in the future.

  4. Decision Table Setup

    • Decision Table 1: Map SO → Category.

    • Decision Table 2: Map BS → SO → Category → Sub-Category Group.

  5. Form Setup

    • Once the decision tables are in place, you can create a lookup table-like behavior on the form.

  6. Client Script

    • Create a client script to call the decision table(s) on the form.

    • This ensures the selections dynamically follow the mapping logic.

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

5 REPLIES 5

AndersBGS
Tera Patron

Hi @chaithanya gund ,

 

Just to pitch - then why? There is a best practice OOTB in relation to business service and service offering according to CSDM. Why have a dependency towards hardware? I would recommend you to challange the requirement instead of doing this, as I could foresee a rather huge overhead of maintaining this.

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/