Forum Discussion
- QuickBaseCoachDQrew CaptainThis is not easy to do.
If you want to prevent duplicates, then you can set the field for claim number to be Unique. But that will block the Save, which may not be your intention.
I have one app where I force the user to indicate in another field that they know it�s a duplicate, then use a formula field to be unique. The formula evaluates to null if that checkbox is checked, this allowing the Save.
If you really want to achieve what you asked, you would initially populate a new table of Unique Claim IDs where the key field is set to Claim ID, using a summary report and copy to other table.
Then set a field in that table to be a formula checkbox field called [Claim ID exists?] set to the value
True
Then lookup to the records based in a relationship on Claim ID. Then fire an Automation to add a Claim ID when the record is added or modified and the lookup of [Claim IDexists?] is unchecked.
Then finally, a summary count if the #of records and lookup down to records.
Then colorize based in that count > 1