Custom Data Rules to protect data import
I enjoyed Daniel Callahan's presentation on data validation using custom data rules during the Virtual Empower 2020. I have deployed some of the concepts he presented in a current project. The ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendFor custom data rules it does not matter how the record is being created. Whether it's been created on a form or by an API or by the import process the nice thing about custom data rules is that they globally apply.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
So if you can see your conditions in words and turn that into a formula then that is all you need to do.
Post back if you're having trouble writing the formula but basically you write a formula that calculates to an error message, and if the error message is blank then the record will save and if it is not blank then it will fail.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Thanks for the info Mark!
------------------------------
Paul Peterson
------------------------------
------------------------------
Paul Peterson
------------------------------