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 David,

No it's needs to be string for other reasons...

Thanks for your reply.

Emma

[Harry Campbell2]

Hi Emma,

Try this line of code instead:

current.tier_1.setDisplayValue(product.tier_1.name);

I had a similar issue recently and this resolved it for me.

[ebaileyybs]

Hi, thanks for your reply - still not working I'm afraid.

[Harry Campbell2]

You could try:

current.tier_1.setValue(product.tier_1.name);

(just changed from setDisplayValue to setValue)

[Harry Campbell2]

Another possibility :

product.tier_1.getValue(current.tier_1.name);