Record Producer reference field is populating sys id value in same field in request created table

[kalyani23]

Hi,

I created a record producer for a table, when i submit request , the reference field for sys_user in record producer is populating as sys id in table request record field . instead of user name, which was selected in request form.

please provide solution for this

regards,

Kalyani.

[Voona Rohila]

Hi Kalyani

Can you share few screenshots of your issue?

[kalyani23]

[Voona Rohila]

Hi Kalyani

Looks like  Associate name field is string type, when you are mapping associate name from your catalog to this form the back-end value will be retrieved (i.e sysid)

You need to change the type of Associate name to reference type or when you are mapping the values you should get the name and map it.

[Upender Kumar]

In the target table change the field from string to reference type.