The data objects feature on banterone allows users to view or edit the Custom Fields for data capture. A user can add a custom field to the existing data object. No new data objects can be added, for adding new data objects users can utilize the ‘Custom Objects’ feature.
Adding a Custom Field in the Data Object
- Login to banterone
- Click on Developer Options
- Click on ‘Data Objects’ from the backend menu
- Click on the edit button
- Insert Name of the Custom Field and Data Type(String, Datetime, Boolean, Number)
- Defining the properties of data type is mandatory.
- String - (varchar/nvarchar and size in characters)
- Datetime - (Date, Time, Datetime, Datetime2, Smalldatetime)
- Boolean - (bit - default)
- Number - (Int, BigInt, Decimal, Float)
- Click on ‘Add’ once property is selected
- Click on ‘Save’ once all custom fields are finalized to confirm the addition to the Data Object.
The user can also select the property of the Custom data field for eg; varchar(variable character length) or nvarchar(non-variable character length) in the case of String data type.
Data Types - The data type of an object determines what type of values an object can have and what operations can be performed on the object.
Data Type Variations on banterone
- Boolean - The Boolean data type can only represent two values: true or false.The Boolean type is the primary result of conditional statements, which are used to control workflow in a program.
- String - A string consists of one or more characters, which can include letters, numbers, and other types of characters. A string represents alphanumeric data. This means that a string can contain many different characters, but they are all considered as if they were text, even if the characters are numbers.
A string data type can be of 2 variations varchar and nvarchar
- varchar data type: It is a variable length data type, used to store non-Unicode characters and occupies 1 byte of space for each character.
- Nvarchar data type: It is a variable-length data type, used to store Unicode characters, and occupies 2 bytes of space for each character
Number - Number data type refers to numerical values only. For storing numbers or performing numeric operations this data type is used.
Number data type variations on banterone
- Int - Integer data type, it takes 4 bytes signed integer i.e. 32 bits ( 232 values can be stored). stores only.
- BigInt - Integer data type, takes 8 bytes signed integer i.e. 64 bits (264 values can be stored).
- Decimal - Represents fractional number values, used to accurately represent any number within the precision of the decimal format
- Float - Represents fractional number values float data type stores an approximate value
Datetime - Datetime date data type is used for values that contain both date and time. There can be various formats to represent datetime in an object based on the requirement of the user.