Filament•3mo ago

Dynamically create a column in the

                Tables\Columns\TextColumn::make('date')
                    ->date()
                    ->sortable(),
                Tables\Columns\TextColumn::make('user_amount')
                    ->searchable()
                    ->toggleable()
                    ->sortable()
                    ->label('Money from Safe'),
                Tables\Columns\TextColumn::make('system_amount')
                    ->searchable()
                    ->toggleable()
                    ->sortable()
                    ->label('System Amount')
                    ->sortable(),
                Tables\Columns\TextColumn::make('difference')
                    ->label('Difference')
                    ->formatStateUsing(function (Model $record) {
                        die($record);
                        return $record->user_amount - $record->system_amount;
                    }),
                Tables\Columns\TextColumn::make('type')
                    ->searchable(),

                Tables\Columns\TextColumn::make('date')
                    ->date()
                    ->sortable(),
                Tables\Columns\TextColumn::make('user_amount')
                    ->searchable()
                    ->toggleable()
                    ->sortable()
                    ->label('Money from Safe'),
                Tables\Columns\TextColumn::make('system_amount')
                    ->searchable()
                    ->toggleable()
                    ->sortable()
                    ->label('System Amount')
                    ->sortable(),
                Tables\Columns\TextColumn::make('difference')
                    ->label('Difference')
                    ->formatStateUsing(function (Model $record) {
                        die($record);
                        return $record->user_amount - $record->system_amount;
                    }),
                Tables\Columns\TextColumn::make('type')
                    ->searchable(),

I want to create a field called difference

12 Replies

codeartisan•3mo ago

Hello members any help

bathishig•3mo ago

public function getPriceDifferenceAttribute() { return $this->price - $this->price2; } in your model Tables\Columns\TextColumn::make('price_difference') ->label('Price Difference'), in your table

LeandroFerreira•3mo ago

You can also use a virtual column: https://filamentphp.com/docs/3.x/forms/fields/checkbox-list#customizing-the-relationship-option-labels

$table->string('difference')->virtualAs('user_amount - system_amount');

$table->string('difference')->virtualAs('user_amount - system_amount');

Tables\Columns\TextColumn::make('difference')

Tables\Columns\TextColumn::make('difference')

Checkbox list - Form Builder - Filament

codeartisan•3mo ago

thank you

bathishig•3mo ago

virtual column look better looks

codeartisan•3mo ago

I cant find any information about a virtual column first one works but the second one is giving me challenges

LeandroFerreira•3mo ago

Did you create the migration and add this column? What is the issue?

codeartisan•3mo ago

no it a dynamic field but the first solution works fine just wanted to try out the second option

LeandroFerreira•3mo ago

Are you using mysql?

codeartisan•2mo ago

Yeah

LeandroFerreira•2mo ago

Create a migration to your table and add this

$table->string('difference')->virtualAs('user_amount - system_amount');

$table->string('difference')->virtualAs('user_amount - system_amount');

Then, you can use this virtual column as a column in you app

Tables\Columns\TextColumn::make('difference')

Tables\Columns\TextColumn::make('difference')

codeartisan•2mo ago

thank you

Gaming

Programming

Dynamically create a column in the