Forum Discussion

DonnaTroestler's avatar
DonnaTroestler
Qrew Cadet
7 years ago

Report all product serial #s from multiple fields

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" ...
Formulas and functions
reports and charts
Tables and fields
DonnaTroestler's avatar
DonnaTroestler
Qrew Cadet
7 years ago
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!