Custom Data Rules
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...
Forum Discussion
Hi Mark,
Thanx a lot. It works perfectly fine and Yes one of the fields is from the relationship table so the ToText worked fine as well.
I am troubling you again for one more help here related to this. Would like to know if we can provide a custom message saying that "This combination of so and so values already exists" if the system detects these unique values.
Regards
Gunsham
------------------------------
Gunsham Lakhiani
------------------------------
Thanx a lot. It works perfectly fine and Yes one of the fields is from the relationship table so the ToText worked fine as well.
I am troubling you again for one more help here related to this. Would like to know if we can provide a custom message saying that "This combination of so and so values already exists" if the system detects these unique values.
Regards
Gunsham
------------------------------
Gunsham Lakhiani
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendOh sorry, I forgot to mention the trick for that. Here is the trick. That field that you just created which is unique. Call it
[This combination of so and so values already exists]
Then try saving a duplicate and you will see how the error message reads. Basically you have to fake the field name to make the error message makes sense
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------