Quickbase ranking based on field value
I have a project - College application. The students can submit application and specify their choice of college and specify a rank for each choice. College - Rank A - 1 B ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI am sorry but I am not understanding your tables in their relationships. Can you clarify that?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Sure . All of the fields are in the same table.
When an applicant submits his form, he has to enter all the information- Name, Email and College rankings. There are only 4 colleges , which are field names, and the applicant needs to specify the rank, for each of these colleges.
All I am trying to do is, when the applicant enters the rank , he should not be able to specify the same rank more than once for each of the different colleges that he can choose from. Please suggest.
------------------------------
Divya (OSSE-Contractor) Pogaku
------------------------------
When an applicant submits his form, he has to enter all the information- Name, Email and College rankings. There are only 4 colleges , which are field names, and the applicant needs to specify the rank, for each of these colleges.
All I am trying to do is, when the applicant enters the rank , he should not be able to specify the same rank more than once for each of the different colleges that he can choose from. Please suggest.
------------------------------
Divya (OSSE-Contractor) Pogaku
------------------------------
- MarkShnier__YouTry something like this as a formula checkbox for Invalid ranking.
Set the four college rank fields to not treat null as zero.
not isnull([College 1 Rank]) and [College 1 Rank] = [College 2 Rank]
or
not isnull([College 1 Rank]) and [College 1 Rank] = [College 3 Rank]
or
not isnull([College 1 Rank]) and [College 1 Rank] = [College 4 Rank]
or
not isnull([College 2 Rank]) and [College 2 Rank] = [College 3 Rank]
or
=not isnull([College 2 Rank]) and [College 2 Rank] = [College 4 Rank]
or
not isnull([College 3 Rank]) and [College 3 Rank] = [College 4 Rank]
Then use form rules or enable Custom Data Rules in Advanced Settings for the table to block the save if that is checked.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Got it. This works perfectly. Thank you for a very quick response.
------------------------------
Divya (OSSE-Contractor) Pogaku
------------------------------