Quickbase ranking based on field value

Question

I have a project - College application. The students can submit application and specify their choice of college and specify a rank for each choice.&nbsp;College - Rank&nbsp;&nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp;1&nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp;2&nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; -&nbsp; &nbsp;3How can i prevent the user from specifying the same rank for more than 1 college? I do not want the user to do this-&nbsp;College - Rank&nbsp;&nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp;1&nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp;1&nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; -&nbsp; &nbsp;1Please suggest.TIA------------------------------Divya (OSSE-Contractor) Pogaku------------------------------

markshnier__you · Answer

np,

Create a field with a descriptive name which will be meaningful to your users such as [You may not choose the same rank more than once]. The reasons for this will become apparent.

Create a formula text field similar to this one

List"-", ToText([Related Student]), ToText([Related Collage]), ToText([Rank]))

I am assuming here that you have tables of Colleges and a table for Students.

Mark this field as "Unique" in its field properties. The reason that you cannot use the student name or the college name in this formula is that you will not be able to flag a field as being unique if it involves look up fields.

Now go ahead ant try to enter a duplicate rank and the reason for the descriptive field name will be apparent.

The Error message which will come up in red which will block the save is an automated message by Quickbase which we cannot control. However we can control the name of the field which gets embedded in that error message so we use that to help explain to the user what they did wrong.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

divya__osse-con · Answer

Thanks Mark. That worked like a charm!------------------------------Divya (OSSE-Contractor) Pogaku------------------------------

divya__osse-con · Answer

Hi Mark,&nbsp;When i tried this approach, it worked initially.&nbsp;But not anymore.&nbsp;The reason that i have identified is because - &nbsp;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.&nbsp;Please suggest.&nbsp;TIA.------------------------------Divya (OSSE-Contractor) Pogaku------------------------------

markshnier__you · Answer

I 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
------------------------------

divya__osse-con · Answer

Sure .&nbsp; All of the fields are in the same table.&nbsp;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------------------------------

Forum Discussion

Quickbase ranking based on field value

Related Content

QuickBase Scripts

Using Pipelines to Archive Records Based on Checkbox

Posting from an HTML form directly to Quickbase

Need help with a query formula for ranking dates.

Quickbase App Issues