Custom order for Joomla users.name with First, Middle and Last Name fields

Hello,We are using:

• Joomla 5
• Community Builder 2.11

Our registration form uses the standard CB fields:

• Code:

  firstname
• Code:

  middlename
• Code:

  lastname

For the names we need the format: We have configured: This correctly affects , but the Joomla user field is still being saved as: Questions:

1. Is there a supported way in CB 2.11 to save Joomla
   Code:

   users.name
   as:
   Code:

   [lastname] [firstname] [middlename]
   during registration and profile updates?
2. Can
   Code:

   Custom Name Format
   be used to populate Joomla
   Code:

   users.name
   , or does it only affect
   Code:

   formatname
   ?
3. Is there a CB Auto Actions or CB Code Field method recommended by CB to synchronize
   Code:

   #__users.name
   with a custom name format?

Thank you!

is still being saved as:

As the parameter suggestions it strictly controls the display format for the formatname field. It does not alter storage.

Is there a supported way in CB 2.11 to save Joomla users.name as: [lastname] [firstname] [middlename] during registration and profile updates?

No. That would result in a name that's out of order in storage so anything splitting the name would become incorrect.

Can Custom Name Format be used to populate Joomla users.name, or does it only affect formatname?

No. Why do you need to do this?

Is there a CB Auto Actions or CB Code Field method recommended by CB to synchronize #__users.name with a custom name format?

That's possible, but then you would immediately break the formatname field behavior. So I do not recommend doing so.

Thank you for the clarification.The reason we need this is that several third-party Joomla extensions use the Joomla core field for automatic data population and do not support CB or custom CB fields.In our locale, the standard format for a full personal name is: For example: Currently CB correctly displays this through , but external Joomla extensions continue to use: which is stored as: Because of this, data is propagated to other components in an incorrect format.I understand that changing is not recommended and may affect software that attempts to split the name into separate parts. However, in our implementation we already store:

• firstname
• middlename
• lastname

as separate fields, and is only used as a display value and as a source for third-party integrations.Could you recommend the best CB-supported method to synchronize from existing CB fields during registration and profile updates?Thank you.

The separate fields are a backup for the name field. I do not recommend modifying the name field. At any rate if you want to do this you can do it with the below. As you've been warned about this already I'll leave it to you to decide risking your data.

Global
Triggers: onAfterUserRegistration, onAfterNewUser, onAfterUserUpdate, onAfterUpdateUser
Type: Field
User: Automatic
Access: Everybody
Action
Field: name
Operator: Set
Value: [formatname]

I would recommend exploring other ways to bring CBs name formatting to other extensions. Either with Joomla events in those extensions or possibly working with developers of those extensions to add Joomla events to allow for this or for them to have CB support built in.

Thank You!