Fields in Officexlr

Introduction to Fields and Field types

In Officexlr, The Fields are the main building blocks of a DocType. The Fields in your DocType enable you to Capture data from your users and store it in an organised way. In Officexlr Platform, you can collect and store data using DocTypes and each field in a DocType used to capture an individual piece of the data.

A DocType in Officexlr works as a sheet in a spreadsheet application or a table in a database program. A field works as a column in the spreadsheet sheet or database table.

There are different types of fields available in Officexlr, each designed to enable you to capture a specific kind of data.

‚Äč

Field Types:

There are different types of fields available in Officexlr, each designed to enable you to capture a specific kind of data, that you can add to your Doctype. Each of these fields powered with different capabilities.

Data:

Small, Single line text field, Enables to capture a single line of plain text or text that can contain any character, for example - Name, email etc.

Text:

Long, multi-line text field, Enables to capture multiple lines of plain text or text that can contain any character, for example - Address, Description etc.

Check Box:

Enables to capture selected or not selected (Yes/No) type of values from a defined checkbox.

Int:

Number field, enables to capture Integer types of Numbers, for example - Quantity, Phone Number etc.

Float:

Decimal Number field, enables to capture Float values or Numbers with a decimal point, for example- Weight, Intrest Rate etc.

Currency:

Number with Currency, Enables to capture monetary value. A currency symbol will be displayed with the input field, For Example - Amount Due, Rate, Grand Total, Salary.

Code:

Enables to capture code string or code block with monospaced text format, for example - Error Message, Report query.

Date:

Enables to capture Date, with Date Picker Calendar and manual input, for example - Date of Birth, Due Date etc. (You can set default date format in System Settings)

Select:

Dropdown field with the fixed option, enables to capture selected value from a defined dropdown menu, for example - Gender, Order Type etc. (You must define Set of Choices / Options in Option Property of the Field).

Link:

Enables relating the data within different Doctypes, by Linking Another Doctype, and allowing users to select Document Record, For example - Employee in Leave Application, Customer in Invoice. (Reference to another document set by Options Property of the field.)

Table:

Enables to capture data in Tabular Form, Tables works as sub-forms in Doctype form view, by configuring fields in table you can add columns in Table and User can add multiple rows in each data table, For example - Item, Rate, Qty, Amount in Invoice; Earning Category, Amount in Salary Slip, Ledger Account, Tax-rate and Tax amount in Tax Table.