Field types

Introduction to Field Types and Configuration in Genio

Genio offers a wide range of field types and configuration options to help you create a powerful and well-organized application that meets your specific requirements.

In this documentation, we will provide an extensive introduction to the various field types, data types, formulas, properties, and display conditions available in the platform. By understanding these options, you can effectively customize your tables and fields to fit your needs and ensure a seamless experience for end-users in the generated application or solution.

Field Types and Data Types

Fields in the Genio Platform are defined in the database field and can be categorized into several data types based on their purpose and functionality. These data types include:

Identification

  • CE: Foreign Key
  • CF: False Key
  • C: Text
  • D: Date
  • DT: DateTime
  • L: Logical

Documents

  • IB: Document
  • ID: N Pages Document

Geographic and Geometric Coordinates

  • GG: Geographic coordinates
  • GS: Geographic shape
  • GC: Geometric coordinates

Form Fields

  • DB: TableList
  • DF: MultiForm

Formulas

Formulas in the Genio Platform can be customized using various formula types, implementation options, and calculation persistence settings.

Formula Types

  • ++: Replica
  • +: Arithmetic
  • +H: Arithmetic (Today)
  • DG: Default once
  • DF: Default always
  • CT: Consulta a Tabela (Table Query)
  • CS: Consulta a Seguinte (Following Query)
  • SR: Related Sum
  • U1: Last Value

Implementation of the Formula

  • Update Replicas
  • Does not update Replicas

Calculation Persistence

  • Application Persists
  • Virtual Database

Properties

CAV (Custom Advanced Queries)

  • Always Included
  • Only in your Table
  • Only on Others
  • Never Include

Display Conditions

Align

  • Right
  • Left

Filling Rule

  • Zipcode
  • VAT no.
  • Banking account number
  • IBAN
  • Social Security No.
  • Uppercase
  • License plate
  • email
  • File
  • Manual Mask

By understanding and leveraging these field types, data types, formulas, properties, and display conditions, you can create a tailored application that meets your specific needs. The Generative AI that powers the Genio Platform offers a powerful and flexible solution for building and customizing your tables and fields, ensuring a user-friendly interface and seamless experience for end-users in the generated application or solution.