Filament•3y ago•

3 replies

Extracting form submission data when there are repeaters and relationships

Hey everyone, appreciate it is getting close to Christmas / Holidays for many so I'll try and keep it brief!

I am in a scenario where I have

stock_products

stock_products

and

bom_products

bom_products

and when creating a

bom_product

bom_product

, I can select multiple

stock_products

stock_products

using a repeater. The data for this is then saved in a bom_stock_products table.

On my BomProduct model, I have a method

stockProducts()

stockProducts()

which the repeater uses for the relationship and everything seems to be working fine.

What I now need to do, is calculate a

cost_price

cost_price

for the

bom_product

bom_product

and this is based off of the

cost_price

cost_price

for all of the

stock_products

stock_products

multiplied by the quantity.

The issue I am having is that the

$data

$data

variable does not contain any information on the

stock_products

stock_products

or their id's so that I can query the

stock_products

stock_products

table.

How would one usually get around this or how can I include the data from the repeater with the relationship to calculate this value.