Custom Data Rules to protect data import

Question

I enjoyed&nbsp; Daniel Callahan's presentation on data validation using custom data rules during the Virtual Empower 2020.&nbsp; I have deployed some of the concepts he presented in a current project.&nbsp;&nbsp;The portion of the presentation that most intrigued me was brushed through but not covered in depth.&nbsp; Daniel mentioned using custom data rules to validate data before importing into the table.&nbsp;&nbsp;Has anyone used custom data rules to validate data before it is imported?&nbsp; I am comfortable with Quick Base formulas but am not sure how write a formula that will look at data during the import process.&nbsp; Does anyone have a suggestion for how best to accomplish this validation process?------------------------------Paul Peterson------------------------------

markshnier__you · Answer

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

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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

paulpeterson1 · Answer

Thanks for the info Mark!------------------------------Paul Peterson------------------------------

Forum Discussion

Custom Data Rules to protect data import

Related Content

Merge Imports

Custom Record Titles

custom email

Pipeline to add Parent record from child import

Parent table with custom key from a formula