Make reference field as choice list

[Naveen Kumar J]

Hi,

I have created a new table in order to get this referred in my incident table. My intention was make this reference field as a choice list. So i have selected my choice list specification as "Dropdown with None". However this does work for few records, when records count get increasing this again getting converting into reference field.

Does anyone come across with this issue ?

Thanks,

Naveen

[srinivasthelu]

Hi Naveen,

Please look at the Reference Fields - ServiceNow Wiki documentation here.

In short, glide.xmlhttp.max_choices system property controls it.

[Naveen Kumar J]

I changed   the value to 65 from 15, but still it shows the reference look up icon.

[rich_dawes]

Hi, Naveen!

I'm not sure if you've been trying this, but there is special documentation on Displaying the Reference Field as a Choice List.   If that is your goal, you want to be sure and have the AJAXReferenceChoice auto-completer set in the Attributes of the field's Dictionary entry (Advanced view).

Note that you can override the system property (glide.ui.max_ref_dropdown) by setting an additional dictionary attribute, max_ref_dropdown with a value.   For instance, having set the Choice field to be "Dropdown with -- None --", you might also have an Attributes setting of:

ref_auto_completer=AJAXReferenceChoice,max_ref_dropdown=20

If you don't specify the extra attribute, you should determine for your own sake what is being defaulted to.   If the system property is not set, the value further defaults to 25.

If the actual number of records on the referenced table—possibly whittled down with a reference qualifier—does not exceed the max_ref_dropdown value, then the display will be as a choice list.   Otherwise, users are presented with a standard reference lookup popup window, via the standard magnifying glass icon, which can be further filtered by any characters possibly entered into the field by the user.   Either way, we're still talking about a reference field, here: it's just a question of presentation.   At some point, a reference lookup window is thought to provide a better user experience, giving users the ability to use the standard Go to and list filter UI mechanisms, allowing them to limit the returned list of choosable items according to the needs of the moment.

You the administrator can set the point at which that display-type switch occurs.   If you think it will be confusing for your users, you might set a max_ref_dropdown value to be high enough to effectively preclude the possibility.   This is not generally advised, but might make sense in some particular case.   Otherwise, consider configuring a more typical auto-completed reference field, which users should be familiar with using, the particulars being detailed in the same Wiki article linked to, above.

I hope this helps!

-Rich

[Pavan Nagidi]

Hi Rich,

Using AJAXReferenceChoice, we can see the display field of the table in the drop down. Is there a way I can point to some other field in the referencing table?

Thanks

Pavan