I have created a custom field of type "Select" and I am using the following parameters to pull the list from the users table:
TABLE: users
COLUMN FOR VALUE: id
COLUMN FOR TEXT: name
SQL WHERE parameter: block=0 AND username NOT LIKE 'test%'
This is working great however when viewing the field in the User Profile you see the "name" as expected but I would like it to be a hyperlink to the profile page of the user name that is being displayed. Is there a way to do this and if not I would like to submit it as a future feature request.
Thanks!