Error trying use createOptionForm to allow new record to be created in RelationManager

[LemonPie22]

I have a RelationManager set up to allow users to attach parts to quotes.

It works fine. Users can select from the existing list of parts and add them to a quote as line items.

But now I want to give users the ability to add new parts from within the RelationManager attach form.

So far, I have it so the user can click on the green "Add line item button":

This opens a modal form:

Notice the "+" sign next to the select. Clicking on this opens another modal form:

When I fill in this form and submit it I get this error:
Select field [mountedTableActionData.recordId] must have a [createOptionUsing()] closure set.

The AttachAction code for my RelationManager table (the new part is the createOptionForm section) is as follows:

// Allow users to add line items (parts) to quote
AttachAction::make('Add')
    ->label('Add line item')
    // Only allow line items to be changed in edit mode
    // TODO: Filament v3 does this automatically
    ->disabled(function (RelationManager $livewire) {
        if ($livewire->pageClass == 'App\Filament\Resources\QuoteResource\Pages\EditQuote') {
                return false;
        }
        return true;
    })
    ->icon('heroicon-s-cog')
    ->color('success')
    ->tooltip('Add line item to quote')
    ->form(fn (AttachAction $action): array => [
        $action->getRecordSelect()
            ->createOptionForm([
                TextInput::make('item_number')
                    ->label('Item number')
                    ->unique(ignoreRecord: true)
                    ->required()
                    ->maxLength(255),
                TextInput::make('name')
                    ->required()
                    ->maxLength(255),
                Select::make('part_type_id')
                    ->relationship('partType', 'name')
                    ->label('Part type')
                    ->required(),
                Select::make('make_id')
                    ->relationship('make', 'name'),
                Toggle::make('is_whole_goods')
                    ->default(false)
                    ->label('Whole goods?'),
                Select::make('condition_id')
                    ->default(1)
                    ->relationship('condition', 'name'),
                TextInput::make('net_price')
                    ->mask(
                        fn (TextInput\Mask $mask) => $mask
                            ->money(
                                prefix: '$',
                                thousandsSeparator: ',',
                                decimalPlaces: 2
                            )
                    ),
                TextInput::make('retail_price')
                    ->mask(
                        fn (TextInput\Mask $mask) => $mask
                            ->money(
                                prefix: '$',
                                thousandsSeparator: ',',
                                decimalPlaces: 2
                            )
                    ),
                Select::make('sales_unit_id')
                    ->label('Price per')
                    ->default(1)
                    ->relationship('salesUnit', 'singular_name'),
                Select::make('location_id')
                    ->relationship('location', 'name'),
                TextInput::make('stock_quantity')
                    ->default(1)
                    ->numeric(),
                Select::make('sales_status_id')
                    ->label('Status')
                    ->default(10)
                    ->relationship('salesStatus', 'name', fn (Builder $query) => $query->orderBy('id')),
            ])
            ->required()
            ->reactive()
            ->afterStateUpdated(
                function (Closure $set, $state) {
                    // initialise price
                    $set(
                        'price',
                        Part::query()->find($state)->retail_price
                    );
                }
            ),
        TextInput::make('group')
            ->numeric()
            ->default(1),
        TextInput::make('price')
            ->numeric(),
        TextInput::make('quantity')
            ->numeric()
            ->required()
            ->default(1),
        TextInput::make('sort')
            ->hidden()
            ->required()
            ->default(1),
    ])
    ->after(
        function (RelationManager $livewire) {
            $livewire->recalculateTotals($livewire, $livewire->mountedTableActionData['group']);
            $livewire->emit('refreshForm');
            $part = Part::query()->find($livewire->mountedTableActionData['recordId']);
            if ($part->stock_quantity) {
                // update stock quantity for part
                $quantity = $livewire->mountedTableActionData['quantity'];
                $part->stock_quantity = $part->stock_quantity - $quantity;
            }
            $part->updated_at = Carbon::now();
            $part->save();
        }
    ),

Any ideas please? I'm using Filament 2 at the moment.

The entire code for my RelationManager:

<?php

namespace App\Filament\Resources\QuoteResource\RelationManagers;

use Filament\Forms\Components\Toggle;
use Filament\Resources\Form;
use Filament\Resources\RelationManagers\RelationManager;
use Filament\Resources\Table;
use App\Models\Part;
use Filament\Tables\Actions\AttachAction;
use Filament\Tables\Actions\DetachAction;
use Filament\Tables\Actions\CreateAction;
use Filament\Tables\Actions\EditAction;
use Filament\Tables\Actions\ViewAction;
use Closure;
use Carbon\Carbon;
use Filament\Forms\Components\TextInput;
use Filament\Forms\Components\Textarea;
use Filament\Forms\Components\Select;
use Filament\Tables\Columns\TextColumn;
use App\Filament\Resources\PartResource;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Model;
use App\Models\QuotePart;

class LineItemsRelationManager extends RelationManager
{
    protected static string $relationship = 'lineItems';

    protected static ?string $recordTitleAttribute = 'item_number';

    public static function form(Form $form): Form
    {
        // Modal view/edit form for line items
        return $form
            ->schema([
                TextInput::make('group')
                    ->numeric()
                    ->required()
                    ->default(1),
                TextInput::make('price')
                    ->numeric()
                    ->required()
                    ->default(0)
                    ->mask(fn (TextInput\Mask $mask) => $mask->money(prefix: '$', thousandsSeparator: ',', decimalPlaces: 2, isSigned: true)),
                TextInput::make('quantity')
                    ->numeric()
                    ->required()
                    ->default(1),
            ])->columns(3);
    }

    public static function table(Table $table): Table
    {
        // List of line items for quote
        return $table
            ->reorderable('sort')
            ->defaultSort('sort')
            ->columns([
                TextColumn::make('group'),
                TextColumn::make('item_number')
                    ->label('Part #'),
                TextColumn::make('name')
                    ->label('Description'),
                TextColumn::make('price')
                    ->money('usd', true),
                TextColumn::make('quantity')
                    ->label('Qty'),
                TextColumn::make('extend')
                    ->money('usd', true)
                    ->getStateUsing(function ($record): string {
                        $extend = number_format(($record->price * $record->quantity), 2);
                        return $extend;
                    }),
                ])
            ->filters([
                //
            ])
            ->headerActions([
                // Allow users to add line items (parts) to quote
                AttachAction::make('Add')
                    ->label('Add line item')
                    // Only allow line items to be changed in edit mode
                    // TODO: Filament v3 does this automatically
                    ->disabled(function (RelationManager $livewire) {
                        if ($livewire->pageClass == 'App\Filament\Resources\QuoteResource\Pages\EditQuote') {
                                return false;
                        }
                        return true;
                    })
                    ->icon('heroicon-s-cog')
                    ->color('success')
                    ->tooltip('Add line item to quote')
                    ->form(fn (AttachAction $action): array => [
                        $action->getRecordSelect()
                            ->createOptionForm([
                                TextInput::make('item_number')
                                    ->label('Item number')
                                    ->unique(ignoreRecord: true)
                                    ->required()
                                    ->maxLength(255),
                                TextInput::make('name')
                                    ->required()
                                    ->maxLength(255),
                                Select::make('part_type_id')
                                    ->relationship('partType', 'name')
                                    ->label('Part type')
                                    ->required(),
                                Select::make('make_id')
                                    ->relationship('make', 'name'),
                                Toggle::make('is_whole_goods')
                                    ->default(false)
                                    ->label('Whole goods?'),
                                Select::make('condition_id')
                                    ->default(1)
                                    ->relationship('condition', 'name'),
                                TextInput::make('net_price')
                                    ->mask(
                                        fn (TextInput\Mask $mask) => $mask
                                            ->money(
                                                prefix: '$',
                                                thousandsSeparator: ',',
                                                decimalPlaces: 2
                                            )
                                    ),
                                TextInput::make('retail_price')
                                    ->mask(
                                        fn (TextInput\Mask $mask) => $mask
                                            ->money(
                                                prefix: '$',
                                                thousandsSeparator: ',',
                                                decimalPlaces: 2
                                            )
                                    ),
                                Select::make('sales_unit_id')
                                    ->label('Price per')
                                    ->default(1)
                                    ->relationship('salesUnit', 'singular_name'),
                                Select::make('location_id')
                                    ->relationship('location', 'name'),
                                TextInput::make('stock_quantity')
                                    ->default(1)
                                    ->numeric(),
                                Select::make('sales_status_id')
                                    ->label('Status')
                                    ->default(10)
                                    ->relationship('salesStatus', 'name', fn (Builder $query) => $query->orderBy('id')),
                            ])
                            ->required()
                            ->reactive()
                            ->afterStateUpdated(
                                function (Closure $set, $state) {
                                    // initialise price
                                    $set(
                                        'price',
                                        Part::query()->find($state)->retail_price
                                    );
                                }
                            ),
                        TextInput::make('group')
                            ->numeric()
                            ->default(1),
                        TextInput::make('price')
                            ->numeric(),
                        TextInput::make('quantity')
                            ->numeric()
                            ->required()
                            ->default(1),
                        TextInput::make('sort')
                            ->hidden()
                            ->required()
                            ->default(1),
                    ])
                    ->after(
                        function (RelationManager $livewire) {
                            $livewire->recalculateTotals($livewire, $livewire->mountedTableActionData['group']);
                            $livewire->emit('refreshForm');
                            $part = Part::query()->find($livewire->mountedTableActionData['recordId']);
                            if ($part->stock_quantity) {
                                // update stock quantity for part
                                $quantity = $livewire->mountedTableActionData['quantity'];
                                $part->stock_quantity = $part->stock_quantity - $quantity;
                            }
                            $part->updated_at = Carbon::now();
                            $part->save();
                        }
                    ),
                CreateAction::make('trade-in')
                    // Allow user to add a trade-in part,
                    // the price of which is taken off the quote total
                    ->label('Add trade-in')
                    // Only allow line items to be changed in edit mode
                    // TODO: Filament v3 does this automatically
                    ->disabled(function (RelationManager $livewire) {
                        if ($livewire->pageClass == 'App\Filament\Resources\QuoteResource\Pages\EditQuote') {
                                return false;
                        }
                        return true;
                    })
                    ->tooltip('Add trade-in to quote')
                    ->icon('heroicon-o-receipt-refund')
                    ->color('danger')
                    ->modalHeading('Add trade-in')
                    ->form(fn (CreateAction $action): array => [
                        Select::make('part_type_id')
                            ->required()
                            ->relationship('partType', 'name'),
                        TextInput::make('group')
                            ->numeric()
                            ->default(1),
                        TextInput::make('name')
                            ->label('Part name')
                            ->required()
                            ->maxLength(255),
                        TextInput::make('price')
                            ->label('Trade in price')
                            ->required()
                            ->numeric(),
                        TextArea::make('description')
                            ->maxLength(255),
                        Select::make('make_id')
                            ->relationship('make', 'name'),
                        Select::make('model_id')
                            ->relationship('partModel', 'name'),
                        Select::make('brand_id')
                            ->relationship('brand', 'name'),
                        TextInput::make('year')
                            ->numeric()
                            ->length(4)
                            ->maxValue(
                                function () {
                                    return Carbon::now()->format('Y');
                                }
                            ),
                        TextInput::make('serial_number')
                            ->label('Serial number')
                            ->unique(ignoreRecord: true)
                            ->maxLength(25),
                    ])
                    ->mutateFormDataUsing(function (RelationManager $livewire, array $data): array {
                        $data['item_number'] = 'TRADE-' . $livewire->ownerRecord->id . '-' . $data['group'] . '-' . rand(1, 9);
                        $data['is_tradein'] = true;
                        $data['is_available'] = false;
                        $data['condition_id'] = 2;  // Used
                        $data['net_price'] = $data['price'];
                        $data['price'] = -$data['price'];
                        $data['quantity'] = 1;
                        $data['sort'] = 1;
                        return $data;
                    })
                    ->after(
                        function (RelationManager $livewire, array $data) {
                            $livewire->recalculateTotals($livewire, $data['group']);
                            $livewire->emit('refreshForm');
                        }
                    ),
                CreateAction::make('aggregate')
                    ->label('Add aggregate')
                    // Only allow line items to be changed in edit mode
                    // TODO: Filament v3 does this automatically
                    ->disabled(function (RelationManager $livewire) {
                        if ($livewire->pageClass == 'App\Filament\Resources\QuoteResource\Pages\EditQuote') {
                                return false;
                        }
                        return true;
                    })
                    ->tooltip('Add subtotals to group')
                    ->icon('heroicon-o-table')
                    ->color('primary')
                    ->modalHeading('Aggregate')
                    ->form(fn (CreateAction $action): array => [
                        TextInput::make('group')
                            ->numeric()
                            ->default(1),
                        TextInput::make('price')
                            ->label('Discount')
                            ->numeric(),
                    ])
                    ->mutateFormDataUsing(function (RelationManager $livewire, array $data): array {

                        // Get subtotal for all line items in group
                        $lineItems = QuotePart::where('quote_id', $livewire->ownerRecord->id)
                            ->where('group', $data['group'])->get();
                        $subtotal = 0;
                        foreach ($lineItems as $lineItem) {
                            $subtotal = $subtotal + ($lineItem->price * $lineItem->quantity);
                            // Assign sort order if not set
                            if ($lineItem->sort == null) {
                                $lineItem->sort = 1;
                                $lineItem->save();
                            }
                        }

                        // Discount specified (in price field)
                        if ($data['price']) {
                            // Add new faux part for discount
                            $part = new Part();
                            $part->item_number = 'DIS-' . $livewire->ownerRecord->id . '-' . $data['group'];
                            $part->name = 'DISCOUNT';
                            $part->is_faux = true;
                            $part->is_available = false;
                            $part->condition_id = 1;  // New
                            $part->save();

                            // Add discount faux part as quote line item
                            $line_item = new QuotePart();
                            $line_item->quote_id = $livewire->ownerRecord->id;
                            $line_item->part_id = $part->id;
                            $line_item->price = -$data['price'];
                            $line_item->quantity = 1;
                            $line_item->group = $data['group'];
                            $line_item->sort = 60;
                            $line_item->save();

                            // Add new faux part for discounted subtotal
                            $part = new Part();
                            $part->item_number = 'NEW-' . $livewire->ownerRecord->id . '-' . $data['group'];
                            $part->name = 'CASH PRICE';
                            $part->is_faux = true;
                            $part->is_available = false;
                            $part->condition_id = 1;  // New
                            $part->save();

                            // Add discounted subtotal faux part as quote line item
                            $line_item = new QuotePart();
                            $line_item->quote_id = $livewire->ownerRecord->id;
                            $line_item->part_id = $part->id;
                            $line_item->price = $subtotal - $data['price'];
                            $line_item->quantity = 0;
                            $line_item->group = $data['group'];
                            $line_item->sort = 70;
                            $line_item->save();
                        }

                        // Add subtotal faux part as quote line item
                        $data['item_number'] = 'SUB-' . $livewire->ownerRecord->id . '-' . $data['group'];
                        $data['name'] = 'LIST PRICE';
                        $data['is_faux'] = true;
                        $data['is_available'] = false;
                        $data['condition_id'] = 1;  // New
                        $data['price'] = $subtotal;
                        $data['sort'] = 50;
                        $data['quantity'] = 0;
                        return $data;
                    })
                    ->after(
                        function (RelationManager $livewire, array $data) {
                            $livewire->recalculateTotals($livewire, $data['group']);
                            $livewire->emit('refreshForm');
                        }
                    ),
            ])
            ->bulkActions([
            ])
            ->actions([
                ViewAction::make()
                ->tooltip('View part')
                ->url(
                    fn (Model $record): string => PartResource::getUrl(
                        'view',
                        $record->part_id
                    )
                ),
                EditAction::make()
                    ->label('Change')
                    // Only allow line items to be changed in edit mode
                    // TODO: Filament v3 does this automatically
                    ->disabled(function (RelationManager $livewire) {
                        if ($livewire->pageClass == 'App\Filament\Resources\QuoteResource\Pages\EditQuote') {
                                return false;
                        }
                        return true;
                    })
                    ->toolTip('Amend line item details')
                    ->after(
                        function (RelationManager $livewire, part $record) {
                            $livewire->recalculateTotals($livewire, $livewire->mountedTableActionData['group']);
                            $livewire->emit('refreshForm');
                            if ($record->stock_quantity) {
                                // update stock quantity for part
                                $orig_quote_qty = $livewire->mountedTableActionData['pivot_quantity'];
                                $new_quote_qty = $livewire->mountedTableActionData['quantity'];
                                // new part stock = current part stock + original quote qty - new quote qty
                                $record->stock_quantity = $record->stock_quantity + $orig_quote_qty - $new_quote_qty;
                            }
                            $record->updated_at = Carbon::now();
                            $record->save();
                        }
                    ),
                DetachAction::make()
                    ->label('Remove')
                    // Only allow line items to be changed in edit mode
                    // TODO: Filament v3 does this automatically
                    ->disabled(function (RelationManager $livewire) {
                        if ($livewire->pageClass == 'App\Filament\Resources\QuoteResource\Pages\EditQuote') {
                                return false;
                        }
                        return true;
                    })
                    ->toolTip('Remove item from quote')
                    ->icon('heroicon-o-x-circle')
                    ->after(
                        function (RelationManager $livewire, part $record) {
                            // If part is faux (e.g. aggregate discount) then delete it
                            if ($record->is_faux) {
                                $record->forceDelete();
                            }
                            $livewire->recalculateTotals($livewire, $record->pivot_group);
                            $livewire->emit('refreshForm');
                            if ($record->stock_quantity) {
                                // update stock quantity for part
                                $record->stock_quantity = $record->stock_quantity + $record->pivot_quantity;
                                $record->updated_at = Carbon::now();
                                $record->save();
                            }
                        }
                    ),
                ]);
    }
    protected function recalculateTotals($livewire, $group)
    {
        // Get all line items in group
        $lineItems = QuotePart::where('quote_id', $livewire->ownerRecord->id)
            ->where('group', $group)
            ->get();

        // Calculate subtotal for group
        $subtotal = 0;
        foreach ($lineItems as $lineItem) {
            if ($lineItem->part->is_faux == false) {
                $subtotal = $subtotal + ($lineItem->price * $lineItem->quantity);
            }
        }

        // Calculate discount for group
        $discount = 0;
        foreach ($lineItems as $lineItem) {
            if ($lineItem->part->is_faux == true and $lineItem->price < 0) {
                $discount = $discount + $lineItem->price;
            }
        }

        // Calculate new total for group after discount
        $discounted_subtotal = $subtotal + $discount;

        // Update totals for group
        foreach ($lineItems as $lineItem) {
            if ($lineItem->part->is_faux == true) {
                // Group subtotal (before discount) has item_number of SUB-{quote_id}-{group}
                if ($lineItem->part->item_number ==  'SUB-' . $livewire->ownerRecord->id . '-' . $group) {
                    $lineItem->price = $subtotal;
                    $lineItem->save();
                // Discounted group subtotal has item_number of NEW-{quote_id}-{group}
                } elseif ($lineItem->part->item_number ==  'NEW-' . $livewire->ownerRecord->id . '-' . $group) {
                    $lineItem->price = $discounted_subtotal;
                    $lineItem->save();
                }
            }
        }
    }
}

[danharrin]

IMO, you should use a CreateAction alongside AttachAction, thats what it was designed for, not this

If you want to fix how it currently is, you need to define a createOptionUsing() function that creates a new instance of the model from the $data and then returns the ID.

[LemonPie22]

Thank you @danharrin. I've changed it to use CreateAction as I should've in the first place. Thanks for getting me back on track.