Show name instead of id in Select relationship field, upon record soft deletion.
When I have a Select field like so:
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?
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_namemutateRelationshipDataBeforeCreateUsing()product_idproduct_name$recordstatus_id
