Forum Discussion

ScottPugh's avatar
ScottPugh
Qrew Cadet
6 years ago

Setting a 'Primary' address- How to ensure only 1 child record has a checkbox checked

I have a location table with a relationship to an Address table.   Each location can have many addresses.  I'd like to add a checkbox to the address table called 'Primary'.  The purpose of this field ...
Forms
Formulas and functions
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
You can set up a formula text field and set it to be unique in Field Properties.

The field should be called [You must only select 1 Primary Address].  You will see why I say that when you test.

The formula would be

IF([Primary?]=true, ToText([Related Location))

The effect will be that non Primary addresses will calculate to null, where duplicates nulls are in fact allowed for a field set to be unique.  But if Primary then only 1 will be allowed.  It's quick to set up and test the user experience.