Filament•10mo ago

Repeater BelongsToMany not working on edit form

i followed the steps from the docs: https://filamentphp.com/docs/3.x/forms/fields/repeater#integrating-with-a-belongstomany-eloquent-relationship This works on creation, but on the edit form it only shows a single record, not all the items. On the Client Resource:

             Forms\Components\Repeater::make('clientLocations')
                    ->relationship()
                    ->simple(
                        Forms\Components\Select::make('location_id')
                            ->relationship('location', 'name')
                            ->required()
                    )
                    ->columns(1),

             Forms\Components\Repeater::make('clientLocations')
                    ->relationship()
                    ->simple(
                        Forms\Components\Select::make('location_id')
                            ->relationship('location', 'name')
                            ->required()
                    )
                    ->columns(1),

ClientLocation Pivot model has:

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

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

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

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

Also when I submit the edit page and change the single record it shows, it gives an error:

update
  `client_location`
SET
  `location_id` = 3
WHERE
  `` = 39
  AND `` = 39

update
  `client_location`
SET
  `location_id` = 3
WHERE
  `` = 39
  AND `` = 39

Repeater - Form Builder - Filament

5 Replies

Remi•10mo ago

For future reference: My newly created Pivot Model didnt have an ID column. This is required. So if you run in to this problem and your pivot table doesnt have an id column. Add it ❤️

KeyMe•7mo ago

adding it where exactly? i though id exists automatically,

KA•7mo ago

What is your table structure?

KeyMe•7mo ago

Order table, Device table, custom DeviceOrder pivot model with id, order_id, device_id, quantity.

KA•7mo ago

you should use BelongsToMany relationship i think

Gaming

Programming

Repeater BelongsToMany not working on edit form