Info
Content
Home Document
⌘K
Version 1.0

Fields

Within the Data Builder section of the Tadabase builder, you can define your app's data structure with data tables, fields, and records.

In the previous article we discussed defining your data structure with data tables, and in this article, we will discuss fields and how each field type can impact your data tables' features and functionality in tracking, calculating, reporting, and automating your data.

What are fields‌?

Fields contain specific types of data that describe an item.
For instance, "Name", "Email Address", "Phone Number", and "Date of Birth" are fields you may use to define a person. Each field, or each detail of information, represents one identifying detail about a person and when grouped together, the values within each field form a full description, or record, of one actual person. 

In Tadabase, a group of common fields define a data table. For instance, a data table of Orders may contain fields including Order ID Number, Order Date, Quantity, etc. The values stored within each field represent one piece of information about each order, and all field values grouped together form a record of one particular order. In your application, each order would be viewed as a record and a data table of Orders would store multiple records of individual orders.

It may be helpful to think of fields as similar to columns in a spreadsheet. Tadabase structures data with data tables, fields, and records, similarly to how spreadsheets structure data with spreadsheets, columns, and rows. Just as like columns define a spreadsheet and the values within each column come together to form a row, common fields define a data table and the values stored within each field come together to form a record.

Field Types

Field types refer to the type of data contained within each field, and each field type comes with its own unique set of features and functionality.

When adding new fields, choosing the correct field type is critical in unlocking your application's full functionality. For instance, using a date field type will allow you to filter your data with complex date formulas and calendar component functionality whereas a number field type will not. Similarly, choosing an email field type rather a text field type for an email address field is critical in unlocking powerful email functionality, such as sending automated emails from your app.

Tadabase offers a variety of field types to accommodate nearly any type of data type you would like to store. The Add Field Menu located on top of each data table divides all fields into seven field type categories: 

2022-01-13_14-13-59.png

Adding fields

You can add fields by selecting them from the Add Field Menu that is located above each data table in Fields, search for a               specific Field, or select the drop down "Field type".

Select New Field

Editing fields

To edit a field, simply click on the field name on the column heading. 

Edit Fields

Alternatively, you can edit fields within the Fields tab of the selected data table's navigation menu. Select the field you wish to edit, and you will see a pop-up with options.

Edit Fields

Reordering Fields

You can rearrange fields within the Fields tab of the selected data table's navigation menu. Simply click on the drag icon of the field you would like to rearrange and drag the field to your desired order location.
Edit Field Order

Reordering fields will not change the order of fields in existing forms or other components within the page builder but will change the default order for new pages in the page builder going forward.

Changing Field Types

If you would like to change a field's type from one type to another, you can do so within the Fields tab of the data table's navigation menu. Click on one of your fields in the Fields tab, then click the drop down as seen in #2 and select an option.

Edit Field Type

Please note: Not all field types can be changed and field types can only be changed to another type within the same field type category. For instance, a date field can be changed to a date/time field type but not to an email field type. 

It is recommended to take some time to plan out your fields and their necessary field types before you begin the process of creating fields as this will help you choose the correct field types from the beginning and avoid having to change field types as your app progresses. This is recommended because changing your field types can result in negative effects on your existing fields as well as on your application overall. For instance, if you change a Rich Text HTML field to a Text field, you will likely see all the HTML tags as plain text within your fields.

Deleting Fields

To delete a field, click on one of your fields located in the Field tab and select the Delete Field button. Once a field is deleted, you cannot undo this delete. 

Deleting a field will remove all the values that are part of that field. For instance, if you delete an Email field, all email addresses contained within this field will be deleted across all records.

2022-01-13_22-29-45.png

Fields cannot be deleted when they are being used as the Connection Display Field within another table. For instance, if you have a connection from the Jobs table to the Customers table and the display field is "Customer Name", you cannot delete the Customer Name field as it is currently being used as the connection display field within another table. To successfully delete this field, you must first change the connection display field to another field.

Please Note: If you delete a connection field that is being used in your app, the automatic relationship will be removed as well. For example, if you have a form that adds a connected record and the connection field is deleted, the form will still function however the record will no longer be auto-connected. 

Field Character Limitations

Small Text 255
Medium Text 500
Long Text 4.2 Million
Rich Text 4.2 Million
Name Title 10
Name First 100
Name Middle 100
Name Last 100
Email 255
Address1 300
Address2 300
Address City 100
Address State 50
Address Country 50
Address Zip 20
Address Lat 15
Address Lon 15
Phone 50
Number 255
Currency 255
Date Any valid date
Time Any valid time
Datetime Any valid date/time
Datetime all Day 10
Checkbox 65,535
Radio 65,535
Select 65,535
Multi Select 65,535
Decision 1
Rating 255
Signature 65,535
Link 65,535
Slider 200
Join 65,535
Basic Formula 100
Date Formula 100
Text Formula 65,535
Equation 4.2 Million
Auto Increment 11
Count 100

 

Field Quantity Limits

The infrastructure that powers your Tadabase Apps, while powerful and robust, does have its limitations.

The table below describes the field quantity limits, or the number of possible fields per Data Table per field type. There is no fixed limit in regard to the total number of fields overall, rather each field type takes up a percentage of space out the full table (100%). The percentage required varies significantly across different field types.

Please reference the table below when planning your Data Tables as Tadabase does not have any control over these limitations.

Field Name Limit  Percentage of Table
Text Field 55 1.82
Long Text Field 175 0.57
Rich Text Field 175 0.57
Text Formula 175 0.57
Basic Formula 145 0.69
Number Field 900 0.11
Currency Field 850 0.12
Auto Increment Field 800 0.13
Equation Field 100 1.00
Multi Select 150 0.67
Checkbox 150 0.67
Radio 150 0.67
Select 150 0.67
Decision Box 750 0.13
Date Time 800 0.13
Date Range 125 0.80
File 150 0.67
Image 150 0.67
Name Field 30 3.33
Email Field 50 2.00
Address 15 6.67
Phone 150 0.67
Signature Field 150 0.67
Link Field 150 0.67
Rating Field 800 0.13
Connection Field 50 2.00

Now that we have discussed how to use fields, we will explore each field type in the following articles.

Back to top