Show name instead of id in Select relationship field, upon record soft deletion.

When I have a Select field like so:

Select::make('product_id')
                    ->label('Product')
                    ->relationship('product', 'name', function (Builder $query, Get $get) {
                        $mealTypeId = $get('../../meal_type_id');
                        $query->byMealType($mealTypeId);
                    })
                    ->preload() 
                    ->required()
                    ->distinct()
                    ->disableOptionsWhenSelectedInSiblingRepeaterItems()
                    ->columnSpan([
                        'md' => 5,
                    ])
                    ->searchable(),

Select::make('product_id')
                    ->label('Product')
                    ->relationship('product', 'name', function (Builder $query, Get $get) {
                        $mealTypeId = $get('../../meal_type_id');
                        $query->byMealType($mealTypeId);
                    })
                    ->preload() 
                    ->required()
                    ->distinct()
                    ->disableOptionsWhenSelectedInSiblingRepeaterItems()
                    ->columnSpan([
                        'md' => 5,
                    ])
                    ->searchable(),

My field shows the group names in the selection options, and when a resource record is created, the product name is also shown in the Select field in the edit form. See first screenshot. If I delete the product that was selected, the Select field in the edit form shows the id of the previously existing product instead of the it's name. See second screenshot. I understand that the non-exising product should not be selectable after it is deleted, but I would love to be able to show the product name instead of the id, when the product has been deleted. Is there a way to force Filament Select fields to use name instead of id in relationships, or do something else that achieves what I want to do?

Solution:

I think what I want to implement is not possible, as the field just shows what is saved in the pivot table record in the database, which is the product_id. So to avoid showing product id's in case the products have been removed, I added a static product_name field to my pivot table, and added this to my filament form, which gets set in mutateRelationshipDataBeforeCreateUsing(). Then I show the Select relationship product_id field or the product_name conditionally, based on the $record...

Jump to solution

7 Replies