Change Name format from User table
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2024 05:52 AM
Hi Everyone,
Name from the User (sys_user) table uses the following format i.e., firstName + " " + lastName; however, we would like to use the following: lastName + ", " + firstName.
Kindly confirm whether you have implemented this. Thank you!
Regards,
Rana
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2024 06:11 AM - edited 09-25-2024 06:12 AM
Hi @Rana5
- Navigate to the sys_user table.
- Right-click on the Name field and select Configure Dictionary.
- Go to the Calculated Value section.
- Update the code on Line 14 to match the code shown in the screenshot below.
Line No 14 code
current.last_name + ' ' + current.first_name;
Please refer to the screenshot for the exact code
Please mark this response as Correct and Helpful if it helps you can mark more that one reply as accepted solution
Thanks
Eshwar