Field dependency between Two fields in Incident form

chaithanya gund · 3 weeks ago

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!

Dr Atul G- LNG · 3 weeks ago

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:

Create BS and SO
- Establish relationships between them.
Create Category and Sub-Category
- Use the System Choice Table for this.
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.
Decision Table Setup
- Decision Table 1: Map SO → Category.
- Decision Table 2: Map BS → SO → Category → Sub-Category Group.
Form Setup
- Once the decision tables are in place, you can create a lookup table-like behavior on the form.
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

AndersBGS · 3 weeks ago

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/