Forum Discussion
Is your plan to allow users to 'repeat' and have lets say 2 items that are 'most' important? My suggestion on how to handle your situation is to just make (7) fields and align them all in a section together on the form so they're grouped, and add some 'text' informing the users of how to fill them out. Each of your fields would correspond to a question and the 'options' in a text-MC would be the same for each as most important to least important.
------------------------------
Chayce Duncan
------------------------------
Building on Chayce's response, my guess is you have seven different features and you want them ranked. One way to do this is to have 7 multiple-choice fields called feature number one rank, feature number two rank feature number three rank, etc. up to seven and each of these will be a multiple-choice field listing all seven possible features.
note that if you make the first field, then it's very easy to copy the field to make the other six.
But then my guess is you don't want to allow them to repeat any feature twice.
Of that is the case, you would use it formula which would be a bit repetitive, but not too bad copy paste to make sure that the same feature was not selected twice.
feel free to post back if you need help making the formula to determine if any of the features were listed twice.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------