Discussions

Expand all | Collapse all

Report all product serial #s from multiple fields

  • 1.  Report all product serial #s from multiple fields

    Posted 01-08-2019 23:09
    I want to print a report of all equipment serial #s for a product we have. The unusual part of this is that the serial #s are in eight different fields within the same record because they're "mapped" to another piece of equipment (a separate bioreactor for each piece of equipment), which is how we need the entire record to be displayed.

    So, I want to print a report that lists all serial numbers and the company they're associated with, for example:

    235777     ABC Company           Macon, Georgia
    235778     DEF Company           New York, New York
    235779     GeeWhiz Company   San Francisco, CA
    235780     XYZ Company           Seattle, WA

    I created a field called "All Serial #s" and below is what I've got in the Formula - Text field. It works "sort of" in that I don't get an error message (!). However, it doesn't appear that it getting all of the serial #s. Any initial thoughts of what I might be doing wrong?

    If(

    Trim([Serial #1])<>"", ToText([Serial #1]),
    Trim([Serial #2])<>"", ToText([Serial #2]),
    Trim([Serial #3])<>"", ToText([Serial #3]),
    Trim([Serial #4])<>"", ToText([Serial #4]),
    Trim([Serial #5])<>"", ToText([Serial #5]),
    Trim([Serial #6])<>"", ToText([Serial #6]),
    Trim([Serial #7])<>"", ToText([Serial #7]),
    Trim([Serial #8])<>"", ToText([Serial #8]))



  • 2.  RE: Report all product serial #s from multiple fields

    Posted 01-08-2019 23:15
    Can you provide an example of a record with an incorrect result and what is in each of those 8 fields for that 1 record?



  • 3.  RE: Report all product serial #s from multiple fields

    Posted 01-09-2019 16:36
    Great question! Took me a little bit to figure out, but it looks like it's picking up just the first serial # on each record (Serial #1). Attached a screenshot of the record that contains the fields. NOTE: In my original submission, I used the generic [Serial # x] for field names, instead of their real field names, which are "Seg-Mod 1," "Seg-Mod 2," "Seg-Mod 3," etc. Also, Vessel Connections are the bioreactors. Thanks for your help!






  • 4.  RE: Report all product serial #s from multiple fields

    Posted 01-09-2019 16:44
    So in the example above are you looking to list those first 6 Seg-Mods all together.  I'm unclear as to an example of the response that you want.


  • 5.  RE: Report all product serial #s from multiple fields

    Posted 01-09-2019 16:46
    You probably want just this

    List("\n",
    [field 1],[field 2],[field 3] ... [field 8])


    That would list them in a single field vertically.




  • 6.  RE: Report all product serial #s from multiple fields

    Posted 01-09-2019 16:47
    The goal is a sequential list of all Seg-Mod serial #s and where they are located. So, I want each Seg-Mod to be listed on a separate line on the report (and the Company and Location for each).


  • 7.  RE: Report all product serial #s from multiple fields

    Posted 01-09-2019 17:10
    I've used the formula you indicated and think this will work just great for our purposes. THANK YOU