Custom Validation Message for Required Pivot Select Field in Backpack Relationship Field

[ceeckhout]

I have created a relationship field in my ProductCrudController:

CRUD::field('articles')
    ->label('Artikelen')
    ->type('relationship')
    ->entity('articles')
    ->subfields([
        [
            'name'          => 'custom_title', 
            'label'         => 'Aangepaste titel',
            'type'          => 'text',
        ]
    ])
    ->pivotSelect([
        'label'         => 'Artikel', 
        'attribute'     => 'title',
    ])
    ->new_item_label('Artikel toevoegen')
    ->pivot(true)
    ->init_rows(0)
    ->min_rows(0)
    ->reorder(true)
    ->reorder('sort_order');

I need to add a custom validation message for the required pivot select field (the title attribute in the pivot relation) in my ProductRequest.

Here’s what I want to achieve:

• Validate that the title field in the pivot table is required.
• Provide a custom validation message like: "Please select an article or remove the empty block."
• The field custom_title should remain optional.

My current challenge: I’m unsure what the label should look like in the rules() and messages() methods to target the pivot field validation specifically.

Could anyone guide me on how to correctly define the validation rules and messages for this case?

Thanks!!

[backpack-ai-bot[bot]]

To add custom validation for the required pivot select field in your Backpack relationship field, you need to modify your ProductRequest class. Based on the information from the knowledge sources, here's how you can achieve this:

1. In your ProductRequest class, add the validation rule in the rules() method:

public function rules()
{
    return [
        'articles.*.articles' => 'required',
        // other rules...
    ];
}

2. Add the custom validation message in the messages() method:

public function messages()
{
    return [
        'articles.*.articles.required' => 'Please select an article or remove the empty block.',
        // other messages...
    ];
}

The key articles.*.articles targets the pivot select field for each item in the repeatable field. The * wildcard is used to apply the rule to all items in the repeatable field.

It's important to note that the field name in the validation rules and messages should match the name you've given to the relationship field in your CRUD controller, which in this case is 'articles'.

The custom_title field will remain optional unless you explicitly add a validation rule for it.

For more information on validation in Backpack, you can refer to the Backpack CRUD documentation.

If you need to further customize the validation messages or behavior, you might want to look into overriding the store() or update() methods in your CrudController, as mentioned in this GitHub issue comment.

Remember that validation for repeatable fields and pivot fields can sometimes be tricky. If you encounter any issues, double-check that your field names in the validation rules exactly match those in your CRUD field definition.

ℹ️ Please note our AI Bot does not reply to follow-ups, this will be the only AI answer in this thread. If the AI helped you find the answer, please mark it as answered or write details below so it can learn. Then close the conversation. If not, please give more information for when a human reads this. ℹ️

Relevant sources:

Github Issue (closed): [Bug] Unexpected "The pivot field is required" form validation error message for relationship field
Always apply field validation, on top of array & formRequest validation
Github Issue (closed): [Bug] Cannot specify pivot field as optional
Github Issue (closed): [Bug] Red asterisk is not added in the label on array validation
Too many queries n-n relation
2. CRUD Operations|Fields Part 3
Github Issue (closed): [Bug] Pivot attribute not settable when no title field exists
Github Issue (closed): [Bug] repeatable subfield error messages are a bit odd
Github Issue (closed): [Bug] 'validationRules' => 'required' no longer effective on Repeatable
Fields|Configuring the Pivot Select field
Github Issue (closed): [Bug] Field relationship_select causes QueryException when validation fails.

[jcastroa87]

Hello @ceeckhout

I'm glad our Bot was able to answer your question.

I will close this issue, but please feel free to re-open or create a new one if needed.

Cheers.