I may be on the edge of crazy to even ask such a thing, but I have a scenario where I'm exporting Invoices into a 3rd party application that simply needs Item IDs (SKUs) listed in-line within a single text field. I can deliver the NetSuite data to the application using a Saved Search, but as we know, Saved Searches of Invoices will divide each Item into its own row.
Here's an example of the data as it is now:
I'm wondering if there's a way for me to "roll up" or concatenate the Item data into 1 row that reads something like "40.000004 || Delivery" (where || could be any delimiter).
I'm imagining a Formula (Text) row with a formula something like:
CONCAT((CONCAT({line1item}," || ")),{line2item})
But I just don't know if it is even possible to reference more than 1 line from the same results row. Perhaps a Summary of some kind might be an option too/instead?
Thanks for indulging my marginal thought here. I completely understand if it's not possible and I'm effectively asking for "an orange to look and taste like an apple." ?
-Tim-