Filament•2y ago

Form Select - Relationship customise display?

I'd like to customise the name of a relationship via i.e. instead of id, name. I'd like: id, concat(name, '-', id) Is there a way to do this?

4 Replies

Patrick Boivin•2y ago

Maybe something like this

    Select::make('category_id')
        ->relationship('category', 'name_id', function (Builder $query) {
            return $query->select(DB::raw('`id`, `name`, concat(`name`, "-", `id`) as `name_id`'));
        })

    Select::make('category_id')
        ->relationship('category', 'name_id', function (Builder $query) {
            return $query->select(DB::raw('`id`, `name`, concat(`name`, "-", `id`) as `name_id`'));
        })

toekneeOP•2y ago

Ahh perfect! I always forget about these hidden closures

Ander•17mo ago

@toeknee_iom

->getOptionLabelFromRecordUsing(fn (Model $record) => "{$record->name} - {$record->id}")

->getOptionLabelFromRecordUsing(fn (Model $record) => "{$record->name} - {$record->id}")

Ander•17mo ago

https://filamentphp.com/docs/2.x/forms/fields#dependant-selects

Filament

Fields - Form Builder - Filament

The elegant TALL stack form builder for Laravel artisans.

Gaming

Programming

Form Select - Relationship customise display?