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
Qrew LegendFormula 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
------------------------------
------------------------------
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
------------------------------
