Show name instead of sys_id in string field populated by variable

[ebaileyybs]

Hi,

I have a variable which is referencing a list of data in a bespoke table (x_yobs_regulatory_regulatory_breach_tier_1)

The variable is tier_1

I want the name of the data entry to appear in a mapped string field on the associated table instead of it's sys_id. The field needs to be string for another purpose so this cannot be changed.

Currently when the form is submitted it show the sys_id as below but I need it show show the label/name

How can i achieve this?

Thanks in advance.

Emma

[marcguy]

sorry just put it like this

gs.log(producer.tier_1.name);

gs.log(producer.tier_2.name);

gs.log(producer.tier_3.name);

then go to the system log and check the entries they can be found here (or just type logs in the navigation filter)

https://instancename.service-now.com/syslog_list.do?sysparm_userpref_module=ab0b7690c0a8016400bdb859...

[ebaileyybs]

Hi, what info do you need from the logs?

[Goran WitchDoc]

I think you dont have set any column to be the display value. If you don't set any field to "true" it will show the sys_id as "displayname".

Here you can read more about it: Select a field as the table display value

//Göran

[ebaileyybs]

Hi Goran,

Thanks for your reply - I've already tried this and it didn't make a difference

Thanks,
Emma

[Dave Smith1]

Emma Bailey wrote:
I'm not able to use lookup select box as the the fields are dependent and the data doesn't transfer through correctly.

Thanks,
Emma

Can you make it a reference field? It should then just be a matter of dot-walking to the desired field.