Enforcing Uniqueness on a Formula Field
I have created a formula field on my Project Status record to concatenate Project record id (totext version of it) and a date field on the project status record (child of project). I would like to...
Forum Discussion
Avoid using any look up fields, instead use the reference. Reference usually has "Related" as prefix. Also avoid using any formula fields.
------------------------------
Aswin Babu
------------------------------
------------------------------
Aswin Babu
------------------------------
- MarkShnier__You
Qrew Legend
Formula fields are fine as long as they do not refer to look up fields or summary fields or the native date created or date modified fields.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- That was something that I missed. Thanks, Mark!!
------------------------------
Aswin Babu
------------------------------ You could try "Build custom data rules for this table"
For my table I concatenate several fields into 1 formula text field. One field uses a lookup field which throws the "check for duplicate" error.
However, if you take that same field and use it in a custom data rule it will alert the user that there is a duplicate entry.If(Size(GetRecords("{29.EX.'"&[Duplication Check]&"'}"))>1,"This is a duplicate record.")29 is the field ID of [Duplication Check]
------------------------------
David Semitekol
------------------------------
