Return to FileMaker.com
summing text from line items to one field
I need to create an emailable pull sheet based on my invoice line items.
it needs to select the item name and qty from the related line items and paste all the data into one field so i can write an email script.
any help would be appreciated. Thank you.
You'll need two calculation fields:
LineItems::ItemNameAndQty = item name & " " & Quantity
Inventory::YourResultField = List ( LineItems::ItemNameAndQty )
Retrieving data ...