Topics

Filament•6mo ago

update relative table

I have a product resource class where in the main form I have only fields that belongs to the products table and all updates go fine. Now, if I add two more fields to the main form, like gross_price, net_price. I want to store them in a table named product_prices. When I try to update the price fields that are the product_prices table, I get an error

update
  `products`
SET
  `price_gross` = 2,

update
  `products`
SET
  `price_gross` = 2,

It tries to update the products table and not the product_prices table.  What to do in order to be able to also update the relative tables when I update any of the fields in the form? Thanks in advance!

Solution:

If the fields are from a table with relationships defined, then the field name in the form would need to take the form of "relationshipname"(dot)"fieldname". So, if your product model has a prices relationship to the product_prices table, then your form field for gross_price would probably be FieldType::make('prices.gross_price') and then the update would be saved to that relationship

Jump to solution

4 Replies

Solution

DrByte•6mo ago

If the fields are from a table with relationships defined, then the field name in the form would need to take the form of "relationshipname"(dot)"fieldname". So, if your product model has a prices relationship to the product_prices table, then your form field for gross_price would probably be FieldType::make('prices.gross_price') and then the update would be saved to that relationship

DrByte•6mo ago

If you're already "doing" that, then please post the code for your models' relationships and for your form, and any methods you've overridden for manipulating data or queries for saving and retrieving

DrByte•6mo ago

https://filamentphp.com/docs/3.x/forms/advanced#saving-data-to-relationships

Advanced forms - Form Builder - Filament

Stefan•6mo ago

thanks!

Filament is a collection of beautiful full-stack components for Laravel.You can get help using it on our Discord.

15KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

Relation Manager dependencyI've got a relation manager, and I'm looking to introduce a dependency. This would narrow down the v relation manager in tabHow do I insert the relation manager in my own tab? I have tabs in the form and I want to insert the Add multiple translation to translation table***SOLVED*** Hi everyone, I've been working on a Laravel project and encountered a perplexing issue Test form component's actionIs there a way of interacting with individual form components inside a form? E.g how to call add a record in Create Record is nullAccording to the docs, this should output the record before it gets created, however it shows up nul Defining max items for blocks in Builder form componentHi there, i want to define max items for a block of builder is there any way ? something like this: Path ForwardHello all I’m trying to work out the best path forward. I want to rebuild my current app with fila Use Filament layout/design outside of the panelHi, i have a filament application with the included authentication. I like the design of the login why would app.js not get loaded?I have the below code in my app.js file. ApexCharts is not defined when I try to reference it in the Is it possible to add a mask to an email?Is it possible to add a mask to an email? I need to force the user's hand to not be able to write v