F
Filament•11mo ago
Connor

How to add a sum of related fields in Form/Components/section

So I have a side panel next to my Leads form, 
                Forms\Components\Section::make()->schema([
                    Forms\Components\Placeholder::make('created_at')
                    ->label('Created at')
                    ->content(fn (Lead $record): ?string => $record->created_at?->diffForHumans()),

                    Forms\Components\Placeholder::make('updated_at')
                    ->label('Last modified at')
                    ->content(fn (Lead $record): ?string => $record->updated_at?->diffForHumans()),

                    // sum of related services
                ])
                Forms\Components\Section::make()->schema([
                    Forms\Components\Placeholder::make('created_at')
                    ->label('Created at')
                    ->content(fn (Lead $record): ?string => $record->created_at?->diffForHumans()),

                    Forms\Components\Placeholder::make('updated_at')
                    ->label('Last modified at')
                    ->content(fn (Lead $record): ?string => $record->updated_at?->diffForHumans()),

                    // sum of related services
                ])
The Lead resource hasMany Services. I would like to summarise the value of all these services by 'price' in the side panel next to my lead form. Is this possible and if so, what should I be looking at to figure this out? Appreciate the help!
No description
2 Replies
BlackShadow
BlackShadow•11mo ago
You want the count of all the services? @cnnrp 
// Count
->content(fn (Lead $record) => $record->services->count())
// Count
->content(fn (Lead $record) => $record->services->count())
// Sum by price
->content(fn (Lead $record) => $record->services->sum('price'))
// Sum by price
->content(fn (Lead $record) => $record->services->sum('price'))
Connor
Connor•11mo ago
Oh right, so I can just reference the relationship from this record. I was expecting something more difficult. That's perfect thank you.
Want results from more Discord servers?
Add your server
More Posts
Hide a Toggle field depending on Select optionFor some reason, I can't make it work. Here's what I did: Select::make('roles') ->relationshipopen modal with jsI have created custom page which has a modal , I want to open the modal using js after an event , buSet all column titles to headline()Hi- I have lots of two-word column names, and I'd prefer table columns to use headline case, eg "CreHow to update form query after livewire parameter changeI currently have this code in a child component: ```php class BanTable extends Component implements Is it possible to run jobs after a form is submitted?I have been trying to run a job that alters a different table in the same database after the form isCan i inject methods to Component like inputi need to inection a new method to input component like trait use Cloneable; use HasActionsdatetime picker multipleits possible to make the datetimepickermultiple ? or do you know any package? I can't found anythingwhen my controller is run can i update live wireWhen my controller function is run can i update liveware like emit actionPreload a relationship select if a parent select has a valueI'm currently creating a form where the user can pick an item, either by starting from the very firsConfigurable string prefix to singular resource model nameI have attached a picture. The text in english would be "Create a {singular model name}". That prefi