Beezr Docs
Platform Documentation
Field Management

Now that we’ve created our business Modules, it’s time to start giving those Modules the attributes that define their meaning and purpose. The process of creating the fields of the Module can go from simple to complicated depending on the business the developer needs to implement.

Go to the “Field Manager” item in the side navigation menu to open the Field Builder.




The first thing you need to do is choose the Module you would like to work on from the “Choose Module” drop-down menu. Once a Module is selected, the fields are loaded in the table.



You will notice that there is a field already created that ends with (_pr_id), this is the auto-generated key field for your module. The key field is the unique identifier of each record, you will use this field throughout Beezr either to fetch an exact record or update or delete it. 

To create a field, you need to select a Module first then click on the “Add Field” button on the menu bar.


 
Field Name Description
Field Name A descriptive name to the field is added.
Field Type Beezr provides a lot of field types that developers can use. We will discuss each type in detail in the next subsection.
Key Field Defines if this field should be considered as the unique identifier of the record. This field is auto-generated for you, the highlighted red status means that it is already defined.
Visible Field Defines if this field should be visible to users or not.
Virtual Field Defines if this field should have a persisted value in the DB or not. If this field is checked, then data will not be stored in this field but rather computed in runtime. Usually, fields that are virtual will also be smart fields as we will discuss in the field types.
Required Field Defines if this field should be mandatory in the core.
Show in Header Defines if the field value should be part of the record summary header in the Beezr APP.
Field Order Define the order in the view in the record details for the business user in the Beezr APP.
Default Value Define the default value of the field if no value was specified by the business user during creation. This field can also accept Beezl to compute the value.

Field Types

Beezr offers you a wide variety of field types you can choose from and we keep adding more types that better serve your business. To make things clearer, let's break them down into different categories:

1. Basic Types
 
# Field Type Description
1 Text Alphanumeric value
2 Integer Whole number values
3 Decimal Floating number values
4 Long Values larger than the 32-bit range.
5 Boolean True or False value.
6 Date Date-time calendar field.

2. Relation Fields

One of the most commonly used field types, this type is used to relate one module to another. In database terminology, this is the primary/secondary relationship between objects. 

To add a relation, click on "Add Relation" from the options menu. This will show a dialog to define the relation in a simple way:




Select the target module and the field you would like to represent this relationship with. For example, you are in a module called "Sales Order" and want to create a relationship with the "Customers" module. Whenever you open a "Sales Order" you would like to see the customer name that links you to the actual "Customer" record.

3. Lookup Fields

Developers can create fields that have a predefined list of values in a drop-down format. These kinds of fields are called Lookups in Beezr.

Choose “Lookup” in the field type. The view will change as follows:




A new option will appear under the "Field type", Click the quick add plus sign to add a new lookup table and select it from the drop-down. We'll discuss how to add values to your lookups in the "Lookup Manager" section in the documentation.


4. Smart Fields

They are fields that have their value processed during each request. Consider them like spreadsheet formulas but on steroids. You'll use Beezl to script the required formula and logic you to come up with the value.

Choose “Smart Field” in the field type. The view will change as follows:




In the above example, we’ve computed the full name of the customer by concatenating the first and last name of the customer.


5. Business Fields

The platform also hosts a list of advanced components to enable further flexibility while defining the Module Attributes.
 
# Field Type Description
1 Content A field that is capable of holding unstructured content and files.
2 Image Gallery A field that holds a list of images that are later on used to populate the gallery component (part of the Smart View)
3 Signature Shows a light-pen panel in the form to take the user's signature.
4 Rating Star rating field.
5 Barcode This indicates that Beezr will automatically generate a barcode based on the value in the field. This field promotes you to choose the barcode encoding that you want to apply.
6 Currency This field type is suitable when you want to represent monetary values of the data that include comma separation and currency.