Help with Displaying User Name?

[DS-Matt]

Package

Infolist builder

Package Version

v3.3.8

How can we help you?

Hello All -

I'm working on a small proof of concept for my employer and I've set up users with first_name, last_name and created a method on the user model getFilamentName() to access the first name and last name together, however on both the table and info lists I'm trying to display in a badge the full name of each user associated with my resource, but I can't find a method to do that, when I use the textEntry::Make('user'), I can get either first or last name with dot notation, but can't find a way to override that. Am I missing something?

Here is a screenshot of my app:

[leandrocfe]

Could you please share your code?

[DS-Matt]

Yes! Thanks for the quick response.

For my db, I've got the following user and proof migrations:

// User Migration
Schema::create('users', function (Blueprint $table) {
            $table->id();
            $table->string('role')->default('customer');
            $table->string('first_name');
            $table->string('last_name');
            $table->string('email')->unique();
            $table->timestamp('email_verified_at')->nullable();
            $table->string('password');
            $table->rememberToken();
            $table->timestamps();
        });

// Proof Migration
Schema::create('proofs', function (Blueprint $table) {
            $table->id();
            $table->string('pace_id')->unique();
            $table->foreignId('admin_id')->nullable()->constrained('users');
            $table->boolean('is_approved')->default(false);
            $table->foreignId('approved_revision_id')->nullable()->constrained('revisions');
            $table->timestamps();
        });

// Proof User Pivot Table Migration
Schema::create('proof_user', function (Blueprint $table) {
            $table->foreignId('proof_id');
            $table->foreignId('user_id');
        });

Here is my proofResource.php file:

<?php

namespace App\Filament\Resources;

use App\Filament\Resources\ProofResource\Pages;
use App\Filament\Resources\ProofResource\RelationManagers;
use App\Models\Proof;
use App\Enums\Roles;
use App\Models\User;
use Filament\Forms;
use Filament\Forms\Components\Fieldset;
use Filament\Forms\Components\FileUpload;
use Filament\Forms\Components\Select;
use Filament\Forms\Components\TextInput;
use Filament\Forms\Form;
use Filament\Infolists\Components\TextEntry;
use Filament\Infolists\Infolist;
use Filament\Resources\Resource;
use Filament\Tables;
use Filament\Tables\Columns\IconColumn;
use Filament\Tables\Columns\TextColumn;
use Filament\Tables\Table;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Facades\Auth;

class ProofResource extends Resource
{
    protected static ?string $model = Proof::class;

    protected static ?string $navigationIcon = 'heroicon-o-photo';

    public static function form(Form $form): Form
    {
        return $form
            ->schema([
                TextInput::make('pace_id')
                    ->label('Unique Pace ID')
                    ->required()
                    ->maxLength(255),
                Select::make('users')
                    ->label('Customer')
                    ->native(false)
                    ->multiple()
                    ->relationship( modifyQueryUsing:  function (Builder $query) {
                        return $query->where(column:'role', operator: Roles::Customer );
                        })
                    ->getOptionLabelFromRecordUsing(fn (User $record) => (string)$record->getFilamentName())
                    ->searchable(['first_name', 'last_name', 'email'])
                    ->preload()
                    ->required(),
            ]);
    }

    public static function infolist(Infolist $infolist): Infolist
    {

        return $infolist
            ->schema([
                TextEntry::make('pace_id')
                    ->label('Unique Pace ID'),
                TextEntry::make('users')
                    ->badge()
                    ->label('Customer'),
            ]);
    }

    public static function table(Table $table): Table
    {
        return $table
            ->columns([
                TextColumn::make('pace_id')
                    ->searchable(),
                IconColumn::make('is_approved')
                    ->boolean(),
                TextColumn::make('approved_revision_id')
                    ->label('Approved Revision')
                    ->numeric()
                    ->sortable(),
                TextColumn::make('users')
                   ->label('Assigned Customers')
                    ->badge(),
                TextColumn::make('created_at')
                    ->dateTime()
                    ->sortable()
                    ->toggleable(isToggledHiddenByDefault: true),
                TextColumn::make('updated_at')
                    ->dateTime()
                    ->sortable()
                    ->toggleable(isToggledHiddenByDefault: true),
            ])
            ->filters([
                //
            ])
            ->actions([
                Tables\Actions\EditAction::make(),
                Tables\Actions\ViewAction::make()
            ])
            ->bulkActions([
                Tables\Actions\BulkActionGroup::make([
                    Tables\Actions\DeleteBulkAction::make(),
                ]),
            ]);
    }

    public static function getRelations(): array
    {
        return [
            RelationManagers\RevisionsRelationManager::class,
        ];
    }

    public static function getPages(): array
    {
        return [
            'index' => Pages\ListProofs::route('/'),
            'create' => Pages\CreateProof::route('/create'),
            'view' => Pages\ViewProof::route('/{record}'),
            'edit' => Pages\EditProof::route('/{record}/edit'),
        ];
    }

}

EDIT: Here are my model files:

User Model:

<?php

namespace App\Models;

// use Illuminate\Contracts\Auth\MustVerifyEmail;
use App\Enums\Roles;
use Filament\Models\Contracts\FilamentUser;
use Filament\Models\Contracts\HasName;
use Filament\Panel;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;

class User extends Authenticatable implements FilamentUser, HasName
{
    /** @use HasFactory<\Database\Factories\UserFactory> */
    use HasFactory, Notifiable;

    /**
     * The attributes that are mass assignable.
     *
     * @var list<string>
     */
    protected $fillable = [
        'first_name',
        'last_name',
        'email',
        'password',
    ];

    /**
     * The attributes that should be hidden for serialization.
     *
     * @var list<string>
     */
    protected $hidden = [
        'password',
        'remember_token',
    ];

    protected $casts = [
        'role' => Roles::class,
    ];

    public function proofs(): HasMany
    {
       return $this->hasMany(proof::class);
    }

    /**
     * Get the attributes that should be cast.
     *
     * @return array<string, string>
     */
    protected function casts(): array
    {
        return [
            'email_verified_at' => 'datetime',
            'password' => 'hashed',
        ];
    }

    public function canAccessPanel(Panel $panel): bool
    {
        return true;
    }

    public function getFilamentName(): string
    {
        return "{$this->first_name} {$this->last_name}";
    }
}

Proof Model:

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\BelongsToMany;
use Illuminate\Database\Eloquent\Relations\HasMany;

class Proof extends Model
{
    use HasFactory;

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'pace_id',
        'admin_id',
        'is_approved',
        'approved_revision_id',
    ];

    /**
     * The attributes that should be cast to native types.
     *
     * @var array
     */
    protected $casts = [
        'id' => 'integer',
        'admin_id' => 'integer',
        'is_approved' => 'boolean',
        'approved_revision_id' => 'integer',
    ];

    public function admin(): BelongsTo
    {
        return $this->belongsTo(User::class);
    }

    public function approvedRevision(): BelongsTo
    {
        return $this->belongsTo(Revision::class);
    }

    public function users(): BelongsToMany
    {
        return $this->belongsToMany(User::class);
    }

    public function revisions(): HasMany
    {
        return $this->hasMany(Revision::class);
    }
}

[DS-Matt]

Any ideas?

Thanks!

[leandrocfe]

Any ideas?

Thanks!

I would create a virtual column

https://filamentphp.com/docs/3.x/forms/fields/select/#customizing-the-relationship-option-labels

[DS-Matt]

Thanks, that was easy!