logo

NJP

How to Display Two Columns in a Reference Field in ServiceNow | ServiceNow Tutorial

Import · Sep 13, 2022 · video

[Music] hi there my name is laurence tyndall here at glidefast consulting and in today's servicenow tutorial i'm going to show you how to add two columns to a reference field on a form this amazing enhancement only takes a few minutes to implement and provides a ton of value for anyone using the system by having two columns displayed on a reference field you're able to enter additional values to narrow down your search when trying to select a record in a reference field take for example you're logging an incident on behalf of a user and there's several users with the same name within your organization by enabling an additional column let's say email address in this example you'd then be able to see their email address when selecting their name this feature is especially useful when you're referencing a table that uses a non-unique display value and you'd like your users to easily identify the correct record they're looking for now that we've talked about the benefits of this enhancement let's head over to the hardware asset form where we'll add an additional column to the parent field as you can see in the parent field when i enter dell only the assets display name is displayed as an asset manager this list is not currently useful to me because i can't identify which asset i actually want to select in order to add some uniqueness to these values i'm going to add the serial number column as our second column to this reference field to do this right click on the parent field and click on configure dictionary you'll now be taken to the dictionary entry record for the parent field on the asset form the field we'll be working with today to add this additional column is the attributes field if you can't see this field on the form click on that advanced view ui action which will be displayed underneath the related links section of this form now to add the additional column to this field we'll want to start entering our attributes the first one we want to add is ref under scot auto underscore completer equals ajax table completer this attribute enables you to display the value column of the reference table being referenced and any additional columns listed next we're going to add ref underscore ac underscore columns equals serial and the score number this attribute is adding the second column to the reference field which in this instance is serial number and then the final attribute we're going to add is ref underscore ac underscore columns underscore search equals true this search attribute basically enables autocomplete to work with all fields being displayed in the reference field now that we've completed adding these attributes click on the update button you'll now be taken back to the hardware asset form you'll now notice if we enter dell in the parent field the serial number column is available and we can search against these values and that is all for today's tutorial on how to display two columns in a reference field in service now you

View original source

https://www.youtube.com/watch?v=wXfHen0ROk0