Report all product serial #s from multiple fields

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
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]))

Photo of Donna Troestler

Donna Troestler

  • 376 Points 250 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,612 Points 50k badge 2x thumb
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?

Photo of Donna Troestler

Donna Troestler

  • 376 Points 250 badge 2x thumb
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!




Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,612 Points 50k badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,612 Points 50k badge 2x thumb
You probably want just this

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


That would list them in a single field vertically.


Photo of Donna Troestler

Donna Troestler

  • 376 Points 250 badge 2x thumb
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).
Photo of Donna Troestler

Donna Troestler

  • 376 Points 250 badge 2x thumb
I've used the formula you indicated and think this will work just great for our purposes. THANK YOU