Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
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
------------------------------
DavidSemitekol's avatar
DavidSemitekol
Qrew Trainee
3 years ago

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