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

[sudharsanv36]

Hello Emma,

Have you checked, on which column the Display attribute is enabled for the table 'x_yobs_regulatory_breach_table'?

[Robin19]

Hi Emma,

I had this problem too. I have a custom table that I am using like origami to generate multiple different configurations of a record. So sometimes my recordproducer point to a reference field but carry the data in a string field on the origami table. 

This only becomes an issue when users look at the origami record and see sys_ids in the string fields... turns out... yes, users look at the origami record... But I am using Flow designer to automate a whole LOT! So in flow that processes the end of the origami record, I created a step to replace the sys_id in my string field with the name instead. (Of course I had to look up the sys_user_group record first based on the sys_id)