We need to pass the String field data from User table to my Reference field in custom table.

[Chinmay_Batra]

Hi Community,
We have a user table, and I need to transmit the information from that table to my custom table in the reference column so that instead of displaying the name each time, the data from the employee number field will be displayed. We have an OOTB Employee Number (String) field in the user (sys_user) table, and I set it mandatory. Therefore, every time a user fills up this field, the data should be passed to my custom table. For ex, I constructed the table "import target," and one of its fields is a reference type field called "Emp No. (custom table)".

Solution to this is as follows - we need to write Business rule for passing the data (refer attachment) and the data of "Employee number" field which is of string datatype in User (sys_user) should populate into "Emp no" field which is of reference datatype in custom table (ex - import target).

Steps to navigate-
1. Navigate to user table.
2. Right click on banner.
3. Configure Dictionary then find the user table field name (for me is employee_number).
4. Then make that display value to true.
So while selecting the data from reference field every time it will pick the name so instead of populating name we can populate the data as per our requirement and in my case it will be "Employee number".
Please refer the screenshots and share your feedbacks. Incase any doubts please do let me know.

Thank you.

[Aditi1203]

Very helpful.

[Jeff Wentworth]

Thank you so much for this!