How to show attributes for a reference field?

[User205031]

Hi All,

I have a new reference field created which is a referenced to Business App table. Whenever I select a Business App, the field should populate with number field not name field.

I want the 'Number' field to populate instead of the 'Name' field in the new field that I have created.

Please help!

[Brad Bowman]

The field displayed when selecting a record via a reference field will always be the Display value for that table.  You can change the Display value for the Business App table, but just know that this will change it everywhere this table is used in a reference or list, and at the top of the form - Number will be displayed instead of Name below "Business Application" in the gray header bar.  To change the display value, view the table and change the value of the Display field to true for Number and false for Name

[Robbie]

Hi @User205031,

Are you only wanting to display the Business App 'Number' field on the list view?

If so, it is possible to configure the list view to show the 'Number' field column from a table rather than change the display value for the whole table (Which incidentally will change platform wide - so consider this).

In order to implement this, simply go the the list view as show in your above image, right-click on one of the column headers. This should display a menu.

Go to 'Configure' > 'List Layout'. This will display a 'Slush Bucket'. From here you should see your 'Business App' table in green with a + icon next to it. This signifies it's a reference field and form here you can 'dot-walk' and display any of the fields on this table.

You'll also notice an icon that appears above the '>' icon. (See below image) Click on this to show the related fields and simply click on the Number field on the Left hand side to pull it through to the Right hand side.

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.


Thanks, Robbie