In depth

Many of the field datatypes map directly onto fields in the underlying database, however some of the more complex datatypes are specific to the system, and are designed not just with data storage in mind, but also provide user interface functionality.

 

 

 

There are not just the "traditional" datatypes like 'Text' and 'Integer', but also larger types like 'File', which accepts an uploaded file, and functionally-loaded ones like 'Product family' and 'Shipping Band'.

 

 

The Table component is much more than just a mapping of an underlying SQL table. It includes the ability to control the display of various screens shown to users during the data entry process.

 

 

 

 

 

 

 

 

The Table component, at the Events-tab, also includes the ability to define emails (and social media status updates, and other actions) which are sent out when a Table record has been created or edited. There is a great deal of flexibility over who receives the emails, and under what conditions and under what delay conditions. Thus an email might be sent out if a new record is created (as opposed to simply modifying an existing record), and the email might only be sent if fields contain specified values. There is no limit to the number of different emails or other events that can be triggered off the same record-editing event.