I am creating a table that has multiple fields that are the same. I thought I was good with four duplicates and realized I need more. I added the fields but they are not in the correct order:
"Pre-Assessment Coder Assignment" (X5)
"Pre-Assessment Coder Provider Count" (X5)
I currently have the above fields X4 and need to move the 5th to be sequential.
Go to table settings, select the form you want and from the elements tab you can move the field up or down, add new fields and if you select the check box next to the filed it will put it on the same row as the filed above it.
See attached image I have included all three main screens you will need to navigate through.
please let me know how this works out.
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 Yourself
If 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.. ;)