-
concatenate 2 free text format fields
I have this record where I want to concatenate the YEAR and MONTH field into a YEARMONTH field. All fields are free form text. Here is the view of the record: I use this formula in the workflow, after field edit on both month and year the result is that only the year is entered in the YEARMONTH field and I have no clue…
-
How to concatenate Summary fields?
Hi, I am trying to concatenate a group of summarized fields into one value. I am using the pipe '||' to do so, but it results in individual rows of the grouped records. I need it to display as a single row. Any suggestions? I have attached the snapshots of the saved search formula and the actual result before and after…
-
Use Formula to Reference Multiple Item Lines in 1 results row
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…