How I can Fetch data from User table - Full_name, not User email

Frappe Framework
1

Hi,

I got two table. 
1. Goods table 
a. Goods name 
b. Goods parent.
c. Authorized person (fetch from goods parent)

2.Goods parent
Parent name
Authorized person (At this linked field I changed the field with property setter and it worked, it give me full name of user)

Every Parent got a Authorized person (which linked to User table) 
Question:
At Goods table when I fetch data from Goods parent it give me User ID (user email) 
How I can take user full_name ? 

Property Setter or Client script can help me ?
2

Reference: Need user link field i need to show user full name not mail id - #2 by NCP

1 Like
3

Hi @kamransuleymanli:

Core doctypes, like User, are not customizable directly … except using “Property setter” as @NCP well said above.

Sometimes you could use fetch_from property as workaround.

image
image1578×433 23.4 KB

image
image835×215 8.06 KB

This way, after select user on User link field, full name will appear in User name
Hope this helps.

2 Likes
4

Thanks for quick response both,
Actually I found @NCP solution for Goods parent table like this:

image
image1112×551 34.3 KB

But at Goods table it still show it with email:

image
image1083×395 23 KB

5

Table Goods Parent have two things

  1. User (in this email stored)
  2. ID

Above two things also fetch in the Goods Table.

Solution

Add another field e.g User Name in the Goods Parent table and fetch the user name in this field on the selection of user.

Then you will able to create a name field in the Goods table and fetch value accordingly

1 Like
6

Thank you all, and thanks @Usama_Naveed for simplifying
Got similar question. Will try at that too then will return if needed

have a nice day