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

[ebaileyybs]

Hi, still not working - should this be product or producer?

Thanks

[Harry Campbell2]

Sorry, should be producer. Getting myself confused

[ebaileyybs]

Still no luck

[Goran WitchDoc]

is the mapping that is fooling with you. Since you using it, it takes the value it has and not the display value.

You need to uncheck the "mapto field" and do the "mapping" in the script part instead.

For example. I have a reference variable like this that I want to put in description field on the incident:

if I used map to field, I get the sys_id in the description field.

But if I uncheck that field and instead in the script part of the record producer did this:

I got the "name" in description.

Hope this will solve your problem.

//Göran

[sudharsanv36]

Hello Emma,

Could you please try like this and let us know.

producer.tier_1.getRefRecord().name