1. Forum
  2. Plugin Development
  3. Concatenating nameFrom on relation – is it possible?
joelesvensson
joelesvensson

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?

joelesvensson
joelesvensson

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

kai20720
kai20720

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

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

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

1-4 of 4

Please login to reply to the discussion.