I have a problem exporting data to excel files. Problem at LINK field. For example, in the doctype I put a field of type “Link” and “option” to the doctype “User”. However in the doctype “User” I have selected (image below) - This causes the data to show up as the full name instead of the private key(email).
The problem here is when exporting data to an excel file. I want the output data to also be the full name (as shown) instead of the private key (currently email)