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:

  • Actions

    This helper type is deprecated. In case you need help in updating your helpers, contact CrossmarX by filing an issue. 

    Provides a list of all actions in your current application.



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

  • Credit card types

    This helper type is deprecated. In case you need help in updating your helpers, contact CrossmarX by filing an issue. 

    Provides a list of the five common credit card types: American express, diners, eurocard, mastercard and visa.



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

  • Imports

    This helper type is deprecated. In case you need help in updating your helpers, contact CrossmarX by filing an issue. 

    Provides list of all stored imports



  • 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 and insert into foreign class

    This helper type is deprecated. In case you need help in updating your helpers, contact CrossmarX by filing an issue. 

    This helper can only be used in forms. It allows the user to select items from a foreign class. A text field is shown to enter a value for the search. In case no selection is made, the entered text is used to insert a new foreign object.



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

  • Menus

    This helper type is deprecated. In case you need help in updating your helpers, contact CrossmarX by filing an issue. 

    Provides a list with all menus in your running application. The key is a whole number.



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



  • Static lookup list picker

    This helper type is deprecated. In case you need help in updating your helpers, contact CrossmarX by filing an issue. 

    Is developed for one specific application. Is not implemented yet for other applications.



  • Time zone lookup
    -- description yet to come --

  • User classes

    This helper type is deprecated. In case you need help in updating your helpers, contact CrossmarX by filing an issue. 

    Creates a list of user classes



  • 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: