Can I add multiple reference columns to a choice list?

[ServiceNowSteve]

I have a custom application with a reference field on it. The reference field however is set to be a choice list so that the users can quickly select an option from a drop down instead of clicking the search spy glass, having a window pop up and then finding the item in the new window.

This works but I'd like to add another field (Qty) to the drop down display so they can see what item they are selecting plus how many are left.

I've created an attribute that says "ref_auto_completer=AJAXTableCompleter,ref_ac_columns=model;remaining_quantity" but it still only shows the model. Not sure if it matters but the model is the only option on the table with the display set to true.

Can this be done using this setup?

[Willem]

Use it with comma separated like this:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=model,remaining_quantity

[Willem]

Have you tried refreshing the browser and clearing cache?

Is remaining_quantity a field on the Mobile inventory table?

[Willem · Accepted solution]

Choice list does not support that property. Only Reference type variable:

ref_ac_columns

Applicable variables: Reference

Description: Specifies the columns whose display values appear in an auto completion list in addition to the name. Separate column names with a semi-colon. For example, ref_ac_columns=user_name;email;sys_created_on allows auto-complete to match text from the user_name, email, and sys_created_on columns.

ref_ac_order_by

Applicable variables: Reference

Description: Specifies the column that is used to sort the auto completion list. For example, ref_ac_order_by=name sorts the auto-completion choices alphabetically by name.

ref_auto_completer

Applicable variables: Reference

Description: Specifies the name of a JavaScript class (client-side) that creates the list for auto completion choices. Valid class values include:

• AJAXReferenceCompleter: Displays matching auto-complete choices as a drop-down choice-list. The list only displays the display value column of the reference table. If there is no other auto-completion class specified, reference fields automatically use this class.
• AJAXTableCompleter: Displays matching auto-complete choices as rows in a table. The table displays the display value column of the reference table and any columns listed in the ref_ac_columns attribute.
• AJAXReferenceChoice: Displays matching auto-complete choices as a drop-down choice-list. The list only displays the display value column of the reference table. Furthermore, the list only displays up to 25 matching choices. If there are more than 25 auto-complete choices, the reference field instead displays the choices with the AJAXTableCompleter class.

Refer to:

https://docs.servicenow.com/bundle/newyork-it-service-management/page/product/service-catalog-manage...

[Ashwini_ Godala]

Hi @ServiceNowSteve ,

I am also facing the same issue. How did you achieve this?