Smart Form Element – Data Type Tab

The Data Type Tab allows you to control specific characteristics about the element including how the property will be saved when a Smart Form is created, validating value ranges and calculating field values.

Data Type

  1. String – Data type used for most alphanumeric properties. (e.g. – INV123, Steve Johnson)
  2. Date – Data type used only for date values. (e.g. – 09/12/2011)
  3. Number – Data type used for numbers and floating point values. (123, 500.25, 2,545.62)
    1. Decimal Places – Select the number of decimal places used for your number.
    2. Value must be  – Used for choosing specific comparison operators (Can be: Between | Greater  Than | Less Than)
      • Value(s) – Allows you to type in actual value(s) used once specifying comparison operator.
      • Field(s) – Allows you to choose property field data/range to represent the comparison value.
    3. Calculated Field – Check box used to enable a custom numerical calculation based on one or many other fields.
      • Calculated from fields – Click the Configure… button to launch the Calculated Field window.

        Define the calculation for this field. Double click to select or type in the fields to use in the calculation and use the +, -, *, and / operators. Use ( and ) to indicate the order of evaluation if necessary.

    Calculated fields are limited to those in their own sections. For example, you cannot calculate a field in the header section with another field from the details section.
  4. Sum of – A calculation used to sum specific fields in a column.  Use the drop-down menu to select which field should be summed.
  5. Boolean – Data type used for True or False values.
  6. None (label only) – Data type used to place a label (without a field) on the Smart Form.
  7. Save data in generic locale format (for Date and Number data types only) – If checked, this saves the data type in a non-locale specific format. (e.g. – date of 25/02/2011 could become 02/25/2011)  If unchecked,  the same locale format as what is used for the machine’s locale will be used. (e.g. – date: 25/02/2011, number: 2,00)