Hi Mary,
I'm new to QuickBase but not to application development. I just wanted to say that if you have multiple fields with the same name, you are probably designing your solution in a way that is not the most efficient.
I would guess you need to break those fields out into separate tables and relate them, then aggregate the data for your reporting concerns. (That is my opinion because you are using QuickBase, which is built on top of a relational database structure. I would otherwise introduce lots of other fun things, such as NoSQL and whatnot, but I digress..)
I don't know details of your specific concern, so I can't offer a solution, but you might find the following software engineering principal to be useful:
DRY - Don't Repeat YourselfIf you dive into that, you'll soon arrive at another concept known as
Normalization that might help you re-think your current solution.
Maybe not. I'm just trying to be helpful. :)
These principals will help you in the future, whether you decide to go full-nerd or not.. ;)
Thanks,
~Rob