Ninox features twenty different types of fields, each with their own parameters, options and characteristics that users can use to build data models that range from basic and simple to complex.
Irrespective of the type of field, fields all have the following characteristics:
1. They store contents that may be either entered by the end user (via keyboard entry or import) or calculated by Ninox
2. Users can interact directly with the content of a field and manipulate said content without having to interact with the underlying architecture or configuration of the underlying table.
3. Fields, with few exceptions, serve to capture and, subsequently, present discrete data elements (content) that are static in that they represent the characteristics of past events.
These three characteristics lay in stark contrast to the characteristics of formulas where:
1. Formula fields only display the results of calculations and computations executed by Ninox. End users can not enter content directly into a formula field.
2. Users can not interact directly with the content of a formula field. The only way to effect said content is to interact with the underlying formula that created the content result.
3. Formula fields present content that is dynamic in that it changes instantly as any of the inputs (variables) to the formula itself are modified.