- 
		
			
 
					
- 
		
			
 
					
- 
		
			
 
					
- Building blocks of the data model
 - Basic concepts
 - Classes
 - Key fields
 - Local lookup lists
 - Fields and data types
 - Defining the columns of a table
 - Relations between classes
 - Global lookup lists
 - Filters
 - Universal connected classes
 - Deleting foreign records
 - Class inheritance
 - Storage of personal data on test and develop environment (scrambling)
 
 
 
 - 
		
			
 
					
 
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:
