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
Hi Mark,
When i tried this approach, it worked initially.
But not anymore.
The reason that i have identified is because - I have the same table for colleges and students. Colleges are field names with ranks as values, in the student form. So , i cannot use the [Related Student] and [Related College].
I tried to implement the workaround, with just using the college ranks, the system is throwing an error on saving, only when the combination is repetitive. Not the values.
Please suggest.
TIA.
------------------------------
Divya (OSSE-Contractor) Pogaku
------------------------------
When i tried this approach, it worked initially.
But not anymore.
The reason that i have identified is because - I have the same table for colleges and students. Colleges are field names with ranks as values, in the student form. So , i cannot use the [Related Student] and [Related College].
I tried to implement the workaround, with just using the college ranks, the system is throwing an error on saving, only when the combination is repetitive. Not the values.
Please suggest.
TIA.
------------------------------
Divya (OSSE-Contractor) Pogaku
------------------------------
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
------------------------------- 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
------------------------------