Using multiple datafields in one column?

[dermicha56]

Hey!

i am currently trying to find a solution to the following problem:

I would like to display two fields in one column. I didnt see an option in the docs for this case.
My approach in another datatable was to create an always hidden column with other fields.

Am i missing something?

protected $model = User::class;

    public function configure(): void
    {
        $this->setPrimaryKey('id');
    }

    public function columns(): array
    {
        return [
            Column::make("Contact", "email")
                ->format(
                    function ($value, $column, $row) {
                        return '
                            <i class="bi bi-phone"></i> ' . $row->phone . '<br>
                            <i class="bi bi-envelope-at"></i> <a href="mailto:' . $row->email . '" target="_blank">' . $row->email . '</a>
                        ';
                    }
                )
                ->html(),
        ];
    }

[dermicha56]

Understood the builder method more and am using it like this:

public function builder(): Builder { return ContractAgent::query() ->select([ 'id', 'email', 'contract_agent_phone', ]); }

public function configure(): void { $this->setPrimaryKey('id'); }

public function columns(): array { return [ Column::make("Contact", "email") ->format( fn ($value, $row, Column $col) => '<i class="bi bi-phone"></i>' . $row->contract_agent_phone . '<br>' . '<i class="bi bi-envelope-at"></i> <a href="mailto:' . $row->email . '" target="_blank">' . $row->email . '</a>' ) ->html(), ]; }