• Collecting, Reporting and Removing Field Validation formulas...

    By Eric H Romo 2 decades ago

    Is there an easy way to collect(report as text in a Notes document) and/or remove all the field validation formulas on a form? This might be handy in concert with this project.



    I have a db I inherited with many validations, so this would be nice if there was functionality to gather all field validation formulas, as well as an option to remove them (presumably to be replaced with your code).



    Thanks.

    • Design Synopsis, or DXL

      By Julian Robichaux 2 decades ago

      The "built-in" way to look for Input Validation formulas is to run a Design Synopsis on all Forms and Subforms in a database, and do a search on "Input Validation Formula" for the resulting document.



      You could also use a DXL export to search. I don't have any code that specifically looks for Input Validation formulas, but it could be written.



      In terms of removing the existing fields, you could technically do that with DXL, but it might be a little risky. I'd probably recommend a manual effort for that.