Record is showing sys id and not the label in the form record Now Platform

[Pat Surtan]

I created a catalog item that uses category and subcategory. The variable category uses a select box and subcategory uses reference field. In the table itself, both fields are string type. When I navigate to the service portal, the subcategory is showing the name correctly. However, after submitting the ticket the sys id is showing in the form record instead of the name inside the Now Platform.

What am I doing wrong?

[Nick Parsons]

Hi Pat, how are you mapping your reference field to the form field on your table? My first guess is that you're using the Map to field checkbox - but this only appears on record producers not catalog items which you mentioned you're using. 

[Pat Surtan]

Nick,

I am using the Map to field checkbox to map subcategory from the portal to the table column. Sorry, I am using a record producer.

[Nick Parsons]

As far as I'm aware, you can't use the Map to field option to map a specific value from reference field to a non-reference field (ie: a string field in your case). You can try with a look up select box variable, that does give you the option to specify a underlying value for the option you select. 

Since you're using a record producer, it might be easier for you to use the record producer script:

current.subcategory = producer.subcategory.getDisplayValue();

You can update the field names in the above script so they match your actual field/variable names.

[Pat Surtan]

Hi Nick,

Instead of using a script, can I use variable type Reference (record producer) and column type (reference) from the table so that both are the same data type?

[Nick Parsons]

Hi @Pat Surtan - Yes, if you make both reference fields (ie: the subcategory on the form) and you have set the "Display" value for the column you want to be  in the reference field to true on the table that is being referenced (see image in my above post), then the value will appear as expected.