How to hide column based on the conditon

[blessen131]

I was trying to show column name only if the status is completed otherwise hide the name column. visibleInTable is not working!

$this->crud->addColumn([
'label' => 'Name',
'name' => 'name',
'priority' => 1,
'visibleInTable' => function($entry) {
return $entry->status === 'completed';
}
]);

"backpack/crud": "^5.6"

[backpack-ai-bot[bot]]

Based on the information provided in the knowledge sources, I can help you with hiding a column based on a condition in Backpack. The approach you're trying is close, but there's a more appropriate way to achieve this in Backpack. Here's how you can do it:

$this->crud->addColumn([
    'label' => 'Account Number',
    'name' => 'acct_no',
    'priority' => 1,
    'visibleInTable' => function ($entry) {
        return $entry->status === 'completed';
    }
]);

This code should work correctly in Backpack 5.6. The visibleInTable attribute can indeed accept a closure, which is what you're using. This closure receives the $entry as a parameter, allowing you to check the status and return a boolean value to determine if the column should be visible.

However, there are a couple of things to note:

1. The visibleInTable attribute affects the column's visibility in the table view, but it doesn't affect other contexts like exports or the show view.

2. If you want to hide the column in other contexts as well, you might want to use the other visibility attributes mentioned in the Backpack documentation:

   • visibleInModal
   • visibleInExport
   • visibleInShow

For example, if you want to hide the column in all contexts based on the same condition, you could do:

$this->crud->addColumn([
    'label' => 'Account Number',
    'name' => 'acct_no',
    'priority' => 1,
    'visibleInTable' => function ($entry) {
        return $entry->status === 'completed';
    },
    'visibleInModal' => function ($entry) {
        return $entry->status === 'completed';
    },
    'visibleInExport' => function ($entry) {
        return $entry->status === 'completed';
    },
    'visibleInShow' => function ($entry) {
        return $entry->status === 'completed';
    }
]);

This approach should effectively hide the 'acct_no' column when the status is not 'completed' in all relevant contexts.

ℹ️ 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:

Columns|Choose Where Columns are Visible
Github Issue (closed): [Question] Setting column visibility by default
visibleInShow closure
Github Issue (closed): [4.0.9][BUG] 'visibleInTable' column attribute not working
Github Issue (open): [Feature Request] Show/hide columns via AJAX
[Feature] Conditionable trait
Github Issue (closed): I want to show the child Model items inside the Parent setupShowOperation()
List Operation|Export Buttons PRO
[4.0][BUG] Emulate hidden class from 3.6
Github Issue (closed): [Feature Proposal] Conditional fields (aka. hide/show fields depending on other fields, aka. toggle field visibility)

[karandatwani92]

Hey @blessen131

• Hiding the column via visibleInTable is meant to hide the column for the complete table, not per row.
• Only the visibleInShow attribute supports hiding per entry basis.

To hide the content of this particular column per entry basis on the table, you can use closure column:

[
    'name'     => 'acct_no',
    'type'     => 'closure',
    'function' => function($entry) {
            return $entry->status === 'completed'? $entry-> acct_no : " ";
    }
]