How to set the Impact,Urgency field values base on Service,Category & Sub Category

[Rajamouly]

HI All,

I have a requirement to autopopulate the Impact & Urgency field values based on Service (Reference field), Category (choice field) & Sub Category (choice field) on Incident Module.

Is it best practice to autopopulate Impact & Urgency based on Service select-- Any thoughts?

Can anyone assist me on this?

[Musab Rasheed]

Hello,

There is nothing wrong if you populate Impact and Urgency based on one other field but if it depends on more than one field then logic is very hard to implement. You can explore data lookup definition once but in my opinion just stick to one field validation and population those two rather than depending on three fields.

[Rajyamoulali Pa]

Hello Musab, 

Thanks for response, Can't we apply validation on three fields like Category, Sub Category and Service by using Data Lookup Definition?

Is it best practice to apply Data Lookup in three different fields, or We need to write script?

[Musab Rasheed]

I'm not sure about that so please explore more but honestly it will complicate things so I always suggest stick to one or max two fields to do validation but you can explore that, I have pasted link for you.

https://docs.servicenow.com/bundle/tokyo-platform-administration/page/administer/field-administratio...

[Rajamouly]

I am done with Data Lookup already it's working fine for three fields, but the thing is currently we have just 50 Services, so easily we can match going further we will have 2k or 3k Services.

How can we bring off this requirement any thoughts ?