I'm trying to concatenate the first and last name of the backend user model but it doesn't seem to be possible. This is possible in the list as select support CONCAT. However, it doesn't seem to be possible when adding relation drop-downs. Only nameFrom exists. Have I missed something?

I just created a pull request for a new config field called nameFromSelect that supports customizing the SQL select

https://github.com/octobercms/october/pull/1579

Is this already implemented and if yes, how is the correct Syntax? Perhaps:

nameFrom: CONCAT(vorname, ' ', nachname)

or nameFromSelect: CONCAT(vorname, ' ', nachname)

?

Thanx a lot!

Last updated 3 years ago

user:
    label: User
    type: relation
    select: concat(first_name, ' ', last_name)

More info: https://octobercms.com/docs/backend/forms#widget-relation