AnsweredAssumed Answered

Putting field values from multiple related records in a calculation

Question asked by halijan on Nov 2, 2016
Latest reply on Nov 3, 2016 by halijan

Hey everyone,

wondering if I can get a hand combining a field from multiple related records into a single field.

 

Scenario is:

I have two tables:

  1. Orders
  2. Order Items - Items within each order. Each order will have an item record in this table for each item.

They're linked by an order ID

I want to create a textarea field within Orders that lists the name of each product (one per each order item).

I ultimately need to be able to export that order including the field containing all of the items from the related record

 

I've tried calculations and looked at portals, but haven't been able to work out how to get what I'm after in an export-friendly format.

 

Any ideas? Thanks!

Outcomes