Forum Discussion
Here 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..
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
I am going to try this with another test form. I used the dynamic form rules that Chayce recommended. You two rock and I am so appreciative for the help (and the quick turnaround.)
------------------------------
Myoshia Boykin-Anderson
------------------------------