Creating a nested resource using withPivot()

[sinnbeck]

Package

Panel builder

Package Version

v4.

How can we help you?

I have set up a nested relationship as described in the docs. I am extending ManageRelatedRecords as described here: https://filamentphp.com/docs/4.x/resources/managing-relationships#relation-pages

And I set up the pivot as explained here
https://filamentphp.com/docs/4.x/resources/managing-relationships#creating-with-pivot-attributes

In my form

Select::make('lifecycle_stage')
                    ->options([
                        1 => 'Pending',
                        2 => 'Accepted',
                    ])
                    ->required(),

and on my relationship (both ways)

public function projects(): BelongsToMany
    {
        return $this->belongsToMany(Project::class)->using(AccountProject::class)
            ->withPivot('lifecycle_stage');
    }

But when I try to add a record, it throws

Column not found: 1054 Unknown column 'lifecycle_stage' in 'field list'

Has anyone found a way of getting this working, or do I need to use a RelationManager instead?

[leandrocfe]

You mean, in attach action?

[sinnbeck]

Create and attach yes :) I am trying to find a nice way of checking if the resource exists, and if it does not, show a create page, and then create+attach

[leandrocfe]

Could you create a minimal repo on github to reproduce the issue?

[sinnbeck]

I fixed it myself by overwriting the creation handling :)

protected function handleRecordCreation(array $data): Model
    {
        $lifecycleStage = $data['lifecycle_stage'];
        unset($data['lifecycle_stage']);
        $record = new ($this->getModel())($data);

        $record->save();

        /** @var \App\Models\Project $parentRecord */
        if ($parentRecord = $this->getParentRecord()) {
            $parentRecord->accounts()->attach($record, [
                'lifecycle_stage' => $lifecycleStage,
            ]);
        }


        return $record;
    }