How to display multiple fields in one column-row?

[anonymouse703]

Hi! I want to concatenate last_name, first_name and middle_name in one column-row but only one field is displayed.. I also tried to make getter-setters but I don't know how to call the the getters.

This is my syntax

public function addColumns(): PowerGridEloquent
    {
        return PowerGrid::eloquent()
            ->addColumn('id')
            ->addColumn('last_name')
            ->addColumn('first_name')
            ->addColumn('middle_name')
            ->addColumn('username')
            ->addColumn('email');
    }

    /*
    |--------------------------------------------------------------------------
    |  Include Columns
    |--------------------------------------------------------------------------
    | Include the columns added columns, making them visible on the Table.
    | Each column can be configured with properties, filters, actions...
    |
    */

     /**
     * PowerGrid Columns.
     *
     * @return array<int, Column>
     */
    public function columns(): array
    {
        return [

            Column::add()
                ->title('Name')
                ->field('last_name','first_name','middle_name')
                ->searchable()
                ->sortable(),

            Column::make('Username', 'username')
                ->searchable()
                ->sortable(),

            Column::make('Email', 'email')
                ->searchable()
                ->sortable(),
        ];
    }

[abhaypithadiya]

Hey! I know it is an old discussion but if incase someone needs it, here is how you can do it.

Hope this helps.

    public function addColumns(): PowerGridColumns
    {
        return PowerGrid::columns()
            ->addColumn('id')
            ->addColumn('user_name_formatted', function (OrderProduct $model) {
                    return $model->first_name.' '.$model->middle_name.' '.$model->last_name;
            });
    }
    
    
        public function columns(): array
    {
        return [
            Column::make('Name', 'user_name_formatted', 'first_name')
                ->searchable()
        ];
    }