How to get field value instead of sys_id for reference type field????????????

[venkyyy]

Hi Team,

I have created a table "Expenses type" and added the data in it like travel. medical etc..,

Now, i need the data from this table to other field which i am using in other place, i am using in order guide.

I have taken a field and added reference field type to it and linked to above table to fetch the data.

But, i am unable to see the values like travel,medical etc.., but i am seeing their "sys_id" values.

How to resolve this issue?....i need to get the field values not sys_id's.

[Jaspal Singh · Accepted solution]

Hi Venkat,

Check if the tables travel, medical has display value set as Name or some other field. Default for custom tables & some OOB it is sys_id.

All you need is to right click the Name field then mark the display checkbox true.

[venkyyy]

Thanks Jasapl for the response,

Table name is Expenses types.

columns in table are : Expense type.       Data entered into the field expense type are: Travel and etc..,

attaching the screenshot of table.

i am calling this table as reference to other variable created in order guide as shown below. The field is Type of expense and it is reference type which is linked to the expenses types table.

While i am trying to select a value from the type of expense, it is showing the sys_id's instead of field values as per the table.

i am seeing these values instead of travel, medical etc..,

Please help me in this regard to get the values so that i   can move forward in my work.

[Greg42]

You need to configure the list layout to have at least one field otherwise you will get what you see. You click on the burger and go configure > list layout, add at least one field, job done.

[Pradeep Sharma]

Hello Venkat,

If you are trying to set the values via client script then make sure field type is a reference.