Unique() validation with multiple columns
I have a polymorphic relationship between e.g. a
This is doing exactly what it should do, but it causes some troubles in the Filament Panel.
If I add an address the first time, it is no problem.
If I want to add a new address with the same
Which is also something I would expect. Only it returns in a 500 error. What I want is to get a nice validation error somewhere on my form, presumably with the AddressType Select field.
I tried to use this rule:
Then I get a nice validation message below my Select field, but it also triggers when I just update an existing record.
Next, I tried this rule:
This allows me to update and save my existing record, but still when trying to add a new record with the same Address Type, it gives me this error:
So, I want to know how I can the right validation message inside my form, instead of a 500 error. Not sure if this could work because with new records you only know when inserting them into the database if the fields are unique.
How would this work in Filament?
ClientAddressesClientThis is doing exactly what it should do, but it causes some troubles in the Filament Panel.
If I add an address the first time, it is no problem.
If I want to add a new address with the same
address_type_idWhich is also something I would expect. Only it returns in a 500 error. What I want is to get a nice validation error somewhere on my form, presumably with the AddressType Select field.
I tried to use this rule:
Then I get a nice validation message below my Select field, but it also triggers when I just update an existing record.
Next, I tried this rule:
This allows me to update and save my existing record, but still when trying to add a new record with the same Address Type, it gives me this error:
So, I want to know how I can the right validation message inside my form, instead of a 500 error. Not sure if this could work because with new records you only know when inserting them into the database if the fields are unique.
How would this work in Filament?
