[SOLVED] Name format changing

Hello,
Is there a way to change the name format to be displayed as first name and capital first letter of the last name (e.g Dave L.). In the canvas and the login.

You could use CB Query Field to query for and format the name however you like using MYSQL functions. Alternatively you can alter the name format on store using CB Auto Actions or try formatting it using strictly CSS. See the below for CB Auto Actions/CSS possible solutions.

www.joomlapolis.com/forum/153-professional-member-support/229873-solved-formatting#264856

The below query should work for CB Query Field usage.

Hi Kyle,
Thanks for your reply.
Sorry for not being clear enough.
I mean the way that the name is displayed in the canvas and the login.
The name appearances in the canvas and login, is controlled via Name Format parameter in the general tab of CB configuration.
The options in the configuration are: Name Only, Name (username), Username Only and Username (Name).
Formatting the formatname field via auto actions or query or whatever is only controls the way that this field is displayed in its containing tab (In my case it is the Contact info) or list but not in the canvas and the login.
Or may I miss something?

You can create a CB Query Field, place it on a tab in a not shown on profile position, then edit the formatname field and under Parameters > Layouts set the Profile View Value to a substitution of your query field. This should replace the output of the formatname field with your query field, which is formatted how you're wanting.

Hello Kyle,
In the CB configuration I selected "Name Format" to be "Username Only".
I made string manipulations as suggested on layout displaying the field "formatname" and got the desired result. This result is showing only in "Contact info" tab, where the "formatname" resides and in the users list.

So, in Contact info tab I see Dan R. as required and also in the user list.

Still in the canvas I see "UID50" instead of "Dan R".
Still in the login module I see "Hi, UID50" instead of "Hi, Dan R."

There's a separate layout parameter for userlists under Parameters > Layouts as "Userlist Value Layout". None of the layout parameters may affect the greeting in the login module though, but at least profile and userlist usages should display as desired. The canvas header displays whatever the "User Profile Title text" parameter is set to within the "User Profile Page Title" tab, but it's usually a language string that outputs the formatname. You can try setting that parameter to [cb:userfield field="formatname" /].