Hello Filemaker developers,

 

I need some help. I have a portal that could have one or many lines. I need to build a calculation field on the main table that can have all the lines of the portal row. 

 

The result will be used on and email that will be sent to the client. The result should be like this.

 

Ref. 06125654    IMac 24      1,250€

Ref. 06125654    iPad Mini       750€

Ref. 06125654    iPhone 5        650€

Ref. 06125654    iPhoto            250€

 

What king of calculation can I use to build this portal row report inside a calculation field?

 

Thanks for you help and support.

 

Best regards,

Joao Coutinho

Rather than try to come up with a clever calculation, I would suggest to do this with a script.

 

The script would go to the related records in the portal, loop over each record, appends the desired data onto a variable, return to the original layout, and then set the report field to the concatenated result. 

 

You could have the user trigger this script with a button, or you could place a script trigger on a field to fire automatically when new data is added. 

Create a calculation field in the child table ReportLine =  RefNum & Char(9) & Description & Char(9) & Price

 

In the parent table, create a calc field PortalReport = List(YourPortalTable::ReportLine)

 

Char(9) is the Tab character.

I like doughemi's approach.