INN006 - Custom Validations with ESS Data Sources - Peter Cross

Document created by communitymanager on Jun 26, 2016Last modified by mark_baum on Jul 9, 2016
Version 4Show Document
  • View in full screen mode

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