Custom Data Rules

Question

Hi,I have a header table and a detail table where in i am trying to build a validation on my header table on certain field values which should not be repeated.For example i have 3 fields Field A, Field B and Field C I am entering values as A, B and C in the respective fields and save it after which i can enter the detail part of this record. Now i want to build a validation here where in i am entering another record in the header and if i again enter values as A, B, and C then it should stop me from doing this and throw a validation message.Pl advise if the same is possible.Regards------------------------------Gunsham Lakhiani------------------------------

MarkShnierYou · Answer

Yes, this is easy to do, but you will not be using Custom Data Validation.
A formula field can be flagged as being unique. That will mean that the system will not allow duplicates to be saved, the exception being that duplicate nulls are OK.

You will make a formula text field such as

List("-", [Field A], [field B], [Field C]) and flag it as being unique.

Note that these field may not be lookup fields. So if they are from a relationship, say from a table of Employees where the Key Field was [Record ID#], the formula would need to be

List("-", ToText([Related Employee]), [field B], [Field C])

and not

List("-", [Employee name lookup field], [field B], [Field C])

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community