Lookup helpers

For most fields in your application, a static lookup or a foreign class are sufficent, but in case you have further needs, you can use a lookup helper. The next lookup helper types are available:

• Classes
  

  Provides a list with all classes in your running application.

• Countries (ISO 3166)
  

  Provides a lookup list of 2-letter country codes and related labels, as defined in ISO 3166.

• Fields
  

  Provides a list with all fields in your running application.

• Filters
  

  Provides a list of all filters in your application with property "global" checked.

• Forms
  

  Provides a list of forms in your application.

• JAVA plugin helper
  

  A lookup list implemented in a JAVA class file. This option is not available yet for external developers. CrossmarX can program the lookup list in the meantime. If you want to develop the calculation your self, please use Velocity.

• Languages (ISO 639)
  

  Provides a lookup list of 2-letter country codes and related labels, as defined in ISO 639.

• Lookup from foreign class
  

  This helper creates variations on the default lookup for fields with a foreign class.

• Lookup from multi-value field
  

  Creates a lookup list with the values from a multi-value field.

• Population
  

  Creates a lookup list from all values that populates a field.

• Queries
  

  Provides a list with queries stored in the database. The list can contain all queries or only queries related to one class.

• Script
  

  This helper lets you implement a dynamic lookup list using a script.

• Time zone lookup
  

  -- description yet to come --

• User groups
  

  Creates a list of user groups

• Velocity
  

  The Velocity Lookup Helper allows you to create your own lookup list.

To select one of the helpers you go to the tab 'Properties' of the field details. Here you can choose a helper in the "helper" section from the drop down list or choose one by clicking the "select from a list with explanations"-button. After selecting a helper, it's parameters can be editted.

As an example, we can choose the standard country list for our field 'country'. The lookup helper countries (ISO 3166) provides a drop down list with all countries. See below for the result in our application: