How to customize choice list on an individual entry

[chriscorbett]

Hello All,

My apologies if I am posting this in the wrong forum. I was unsure where to put Form/DB related questions...

I have found that a choice list allows you to add choices for a field where these choices are available to all entries in the table. But say I want to have different choice options available for each record in my table. Is it possible to customize a choice list for an individual table entry?

For example, say I want to track data on computer prices like so:

Table: Computer Prices

Computer Name (String)	Price (Choice List)
PC	$250 $500 $750
Mac	$1000 $1200 $1500 $1700

Suppose I want each entry to have its own prices in the choice list as I've demonstrated above. Is this possible? And if so, how is it set up?

I appreciate any feedback or examples of this.

Thanks,

Chris

[Mike Allen]

I would look at dependent values.   You could have the price field dependent on your Computer Name field, have 6 separate price choices, then in the dependent value for the first 3, put PC, and in the second three, put Mac.

Creating New Fields - ServiceNow Wiki

[chriscorbett]

Actually I have a quick follow up. I now have three entries all with different options defined. How do I expose my options field so the different options are available to be chosen once the dependent field is selected?

[Pradeep Sharma]

Hi Chris,

The best way would be to setup Data lookup. For ex : priority is calculated based on impact and urgency.

Data Lookup and Record Matching Support - ServiceNow Wiki

This setup will not involve any scripting too

[chriscorbett]

Thank you Mike. Looks like Dependent Values won out! Though it took a bit of fumbling around to expose the dependent value field and tailor it for the field I needed. For completeness sake, this video also helped: Simple way of Dependent Dropdown values in ServiceNow - YouTube