Choice List from existing table / field

[p_bansal]

Hi All,

I am trying to create field which is "Choice" field, and referring to an exiting Table and field value to be available to my user, instead of creating new choices.

But when i set the source Choice Table & Choice Field, nothing shows up in drop down.

I have tried doing something in Demo system there it works flawless, i want to understand if we are missing some patch or upgrade, this is an test system.

Please see attached file for how i have maintained my settings in "Dictionary".

[andrew_venables]

Hi Pankaj,

You are using the right technique however the field you have chosen to refer to does itself refer to another field.

Take a look at the dictionary for the dl_u_priority.priority filed and you will see that it points to the incident.priority field and takes its choice list from there. You cannot 'daisy chain' these choice lists so instead all you need to do is point your choice list at incident.priority too and you'll be fine.

Andy

[p_bansal]

Hi Andy,

Thanks for your valuable inputs.

It resolved my first problem, now options are available in drop down,

But user wants it to be a suggestion box, so that they can type in or some default value to be maintained.

What happens when i make this field, as suggestion, and click on "Light Bulb" nothing shows up in the list from referene table.

I have seen this working in some other applications, but not sure weather it is customizing or i have write some rule / script.

please help on this as well.

Pankaj

[andrew_venables]

Hi Pankaj,

If you want to make it a suggestion field then you should read up on how these work at Adding Suggestion Fields - ServiceNow Wiki as the values would need to be configured.

However it is a little strange to use a Choice List and a Suggestion field at the same time, the two are very different.

Can you expand a little on what you are trying to achieve? Choice lists provide dropdowns and they can lookup the options from other dropdowns which is what you originally wanted. Suggestion fields are just string fields that offer potential values from a list that can be configured, but any value can be entered. Which is it you are looking for?

Andy