User ID field showing User Name

[Poorva Bhawsar]

Hi Community,

I have a custom table there i have one user id field which is a reference field and referring to sys_user table. But when i am importing demo data into that custom table, its showing user id as user name but i want to display user ids there instead of user names. I have created 4 attributes in this field but that too not working.

Please help me with this so that it can only populate user ids there.

Thanks.

[vchaudhary0]

It may be chance that you have not given proper reference to that field. Try to re-check the reference and if it is correct then go to SYS_USER table and check what is correct backend name of USER_ID field.

[Poorva Bhawsar · Accepted solution]

I checked everything. To display value of user ids i need to set it display = true and it will impact all the tables where that field is being used. As a solution, i created 2 fields one is reference and other is string as i need this to join tables.

[Deepak Negi]

Check your transform maps configurations.

or show us in screenshots how you are doing it

[Poorva Bhawsar]

I already checked it. Shared the solution above. Thank you so much.