INN006 - Custom Validations with ESS Data Sources - Peter Cross

Version 4

    Peter Cross (Valard Construction)

    Session Description

    External data sources sometimes return cryptic error messages and fail to commit your users’ data — even without their even realizing it. By building a custom validation data structure and commit model, you can provide informative, actionable error messages. In this session, we will explore this data-based approach, which can even provide tooltips to guide user input and form the basis of a complete help system.

    What you should know

    Users should be comfortable with scripting, calculations, the ExecuteSQL function, and basic SQL statements. Users should also have some familiarity with object naming and how to create layouts.

    Products & Technologies

    • Pro/Advanced

    Session Materials

    • Please see attachment(s) below.

    What You Will Learn

    • Learn about the issues with standard error messages returns from ESS data sources
    • Integrate contextual help into your interface using tool tips and ExecuteSQL calculations
    • Create a complete, user-maintainable help system for your entire custom app
    • Use script parameters, object names, and design functions to provide the user with dynamic help