- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual
The selected file /tmp/filej8ONVa could not be uploaded, because the destination sites/default/files/css/css_a91cd284035e73ba34d112bfed2f5a16.css is not properly configured. The selected file /tmp/fileYT5E5o could not be uploaded, because the destination sites/default/files/css/css_de1aa27776f1462d2b0d83a80ce4b92d.css is not properly configured.
Fields are the information you want to track about your Items. These may be commonly referred to as “attributes”, “properties”, “columns” (as in a database table), “controls” (for the form components), and often just as “fields”.
Fields are the only necessary tool for saving or retrieving data elements in WorkXpress. A WorkXpress Field combines form elements, input masks, data types, storage methods, storage parts, search comparisons (aka parameters, operators), and display options into a single class of Building Block. Fields are relied upon by all other Building Block types when those Blocks are trying to interact with WorkXpress data.
In particular, a Field must always be associated with either an Item Type or a Relationship Type. The Fields themselves are the stored data, that is, the parameters/attributes about the associated Item Type or Relationship Type.
Most Field settings are global and apply everywhere the Field is found, but some are local.
“Fields” refers to one of the five fundamental Building Blocks. “Field Type” refers to a specific style of Field, for example “Number”, “Short Text”, or “Address”. “Field” refers to a specifc Field Type that was placed in a Layout and is now a part of the application. For example, a builder will put a “Field Type - Address” into a Layout and name this new Field “Billing Address”. “Data”, also “Value”, refers to the specific information stored within a Field about a particular item. For example, “222 Maple Lane” is the data stored in the “Billing Address” field associated with the item “Acme Company” (an Account).
“Creating” a Field refers to the act of adding a Field of some Type into an application.
There are three ways to create a Field:
Note: Methods 1 and 2 above require the Field to be placed into a Layout. Method 3 will allow the creation of Fields that aren't nested in a Layout.
Wizard Questions vary by Field Type. Please see the individual Field Type for details.
Automations vary by Field Type. Please see the individual Field Type for details.
A Field is always “associated with” either an Item Type or a Relationship Type (aka Item Association), and an actual data element is always “about” a specifc item or relationship of the appropriate type (aka Context). For example, in an application the “Account Website” field is associated with the “Account” item type; therefore, a user will create “www.workxpress.com” (a Field) which is about “WorkXpress” (an Account).
Put differently, whereas a Field is always associated with an Item Type or Relationship Type, a data element contained within a Field is always about a specific Item or Relationship. The former is created by the application builder; the latter by the application user.
The distinction is important because Item Association is about defining the application structure, whereas Context is about knowing how to retrieve data. It is possible for a Field to be associated with a particular Item Type, but to have context from an Item of a different Item Type; hence the distinction.
This Item Association enables the Query Builder Tool to facilitate easy development of data queries across complex Relationships. One uses the Query Builer to develop structures that access specific Fields. At runtime, context is then provided to enable retrieval of elements of data that meet the criteria defined by the Query Builder.
Some Field Types are very simple in nature. For example, “Field Type - Short Text” takes whatever value is entered and stores it in a single location. However, some Field Types are complex; “Field Type - Address” takes the value entered, separates its components, and stores it in muliple special locations; “Street”, “City”, “State”, “Zip”.
Field parts can always be accessed as a group, or separately, depending on the business need. Field parts always vary based on the specific Field Type.
Here is a list of Fields with links to greater depth information:
Address Autonumber Bar Code Calendar Checkbox Currency (US)
Date Date and Time Email Address Evaluated Field Field Grid
File Attachment HTML Content Item Picker - Pick Many
Item Picker - Pick One Item Picker - Select Many Item Picker - Select One
Layout Chooser Link Long Text Number Phone Number Select Many
Each Field Type may have unique form elements–some simple, some complex. “Field Type - Short Text” presents a simple label and entry area to the user. “Field Type - Address” presents a multi-part form Field to the user, in anticipation of identifying the Field parts. The “Field Type - Date/Time” Field Type presents both a calendar chooser as well as hour and minute entry areas, and finally an AM/PM select box.
Form elements always vary based on the Field Type.
Using the Expression Builder Tool, there will commonly be multiple options for how to output the data found in a Field. The display options always vary by Field Type. Some are simple, and some are more complex. For example, a “Field Type - Date” is stored as a numeric string that is not easily legible by the average user. When retrieving a date for use in an expression, a more human-readable format is desired. The Expression Builder presents options for outputting the date such as “MM-DD-YYYY” or “month only”.
All expressions are given the option to output a result as “plain text” or “html”, however, this is NOT a Display Option characteristic of Fields.
Each different Field Type is uniquely assigned a set of available search comparisons by WorkXpress. These search parameters may be simple or complex. Some examples:
A Short Text Field allows searching “is”, “contains” and “starts with”, among other examples. A Number Field allows searching “is greater then” and “is less then”, among other examples. A Date Field allows searching “last week”, “this month” and “this year to date” among other examples.
(more)
Fields may operate in one of three possible modes, view, edit or add. Field modes are generally dictated by the parent Layout, however can remain independent of that Layout in some cases (see Field Settings).
Full Field Security, which enables complete independence of the Field from the Layout, is a planned feature. Post here if you need this feature now!
All Field settings are accessed from the Block Editor Tool. There are two ways to access this Tool for a given Field;
Fields have two classes of settings; common settings, and Field Type Specific settings. In addition, some settings are global, and apply everywhere this Field is found, whereas some are local, and only apply in one specific placement of the Field. Some settings are dependent on the type of Layout in which the Field is nested. Each Field Type's specific settings will clarify whether a certain setting is global, Layout local, or Layout Type local.
Most Field Types share the following common settings tabs:
All other settings are specific to their Field Types, and described relative to them.
Some of the most interesting settings are specific to the type of Field that they are associated with: