Creating a Ranking Form Question
Hello All - I have created a survey form that includes a variety of questions. For one of the questions, I would like the user to be able to rank 7 different options from 1-7 Example:
How woul...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendHere is a formula that should work. It seemed to test OK for me. I actually suggest you change your 7 fields to the field names I have used, paste in this formula to a formula text and then you can rename your fields to whatever you want and the formula will auto adjust to the new names.
In order to block the save on blanks or duplicate rankings, you can either use a form rule to Abort the save, or in the advanced settings you can use custom data rules.
The formula makes use of Formula Variables (see link) which makes the formula much easier to read and maintain, compared to a giant single long formula..
var bool BlankRanks =
[Rank 1] = ""
or
[Rank 2] = ""
or
[Rank 3] = ""
or
[Rank 4] = ""
or
[Rank 5] = ""
or
[Rank 6] = ""
or
[Rank 7] = "";
var bool RankOneDup =
[Rank 1] = [Rank 2]
or [Rank 1] = [Rank 3]
or [Rank 1] = [Rank 4]
or [Rank 1] = [Rank 5]
or [Rank 1] = [Rank 6]
or [Rank 1] = [Rank 7];
var bool RankTwoDup =
[Rank 2] = [Rank 3]
or [Rank 3] = [Rank 4]
or [Rank 2] = [Rank 5]
or [Rank 2] = [Rank 6]
or [Rank 2] = [Rank 7];
var bool RankThreeDup =
[Rank 3] = [Rank 4]
or [Rank 3] = [Rank 5]
or [Rank 3] = [Rank 6]
or [Rank 2] = [Rank 7];
var bool RankFourDup =
[Rank 4] = [Rank 5]
or [Rank 4] = [Rank 6]
or [Rank 4] = [Rank 7];
var bool RankFiveDup =
[Rank 5] = [Rank 6]
or [Rank 5] = [Rank 7];
var bool RankSixDup =
[Rank 6] = [Rank 7];
IF(
$BlankRanks=true, "Please compete all 7 Rankings",
$RankOneDup or $RankTwoDup or $RankThreeDup or $RankFourDup
or $RankFiveDup or $RankSixDup, "Please do not Duplicate any of the 7 Rankings")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Since you're doing it on the form you could also consider making different form rules with something like:
When Input 1 is not blank
and any of the following are true:
input 2 is equal to the value in input 1 or
input 3 is equal to the value in input 1 or
input 4 is equal to the value in input 1 or
input 5 is equal to the value in input 1 or
input 6 is equal to the value in input 1 or
input 7 is equal to the value in input 1
Change the value of Input 1 to blank
Rinse and repeat for each element swapping out the inputs with like:
When Input 2 is not blank
and any of the following are true:
input 1 is equal to the value in input 2 or
input 3 is equal to the value in input 2 or
input 4 is equal to the value in input 2 or
input 5 is equal to the value in input 2 or
input 6 is equal to the value in input 2 or
input 7 is equal to the value in input 2
Change the value of Input 2 to blank
This way it actually restricts them from entering the same value twice while they're entering data.
------------------------------
Chayce Duncan
------------------------------
These form rules worked perfectly fine and were easy for me to implement. Thanks so very much for this.
------------------------------
Myoshia Boykin-Anderson
------------------------------
