Logo
For example "scheduled tasks"
Search
Info
Content
Category Navigation
  • 📖  Manual

  • 👋Welcome

    Welcome to Tadabase

    What Is No-Code?

    Tadabase Support

    Getting Started With Tadabase

    Platform Overview

    🧰The Data Builder

    Data Tables

    Fields

    Text Fields

    Personal Fields

    Number Fields

    Date Fields

    Option Fields

    File and Image Fields

    Equation Fields (Category)

    Equation Fields

    Connection Fields

    Date Equation Examples

    Records

    Record Logs

    Import Templates

    Export Templates

    Automating Tasks

    Number Equation Examples

    Text Equation Examples

    Multi-Function Equation Examples

    ✏️Page Builder

    Page Builder Overview

    Layouts

    Pages

    Components Overview

    PDF Pages

    📗System Components

    System Components Overview

    Menu

    User Menu

    Breadcrumbs

    PDF Print (Alpha)

    Link Button

    Login

    Signup

    Profile

    HTML

    Image

    Subscriptions (Alpha)

    📘Data Components

    Data Components Overview

    Form Component

    Table Component

    List Component

    Kanban Component

    Calendar Component

    Resource Component

    Map Component

    Timeline Component

    Accordion Component

    Card Component

    Chart Component

    Search Component

    Import Component

    Data Source

    Data Source Filtering

    Links

    Display Rules

    Inline Editing

    Data Component Visual Directory

    Custom Component

    Custom Component Helpers

    Writing Your Own Component Helpers

    🙋Users

    Users

    Roles

    Single Sign On (SSO)

    Adding Stripe Subscriptions

    🔒Security and Reliability

    Tadabase Builder Security

    App Security

    User Security

    🔗Integrations

    Zapier Integration

    Using Webhooks

    Saving files to Dropbox

    Adding PayPal payment buttons to your app

    Exporting records to Google Sheets

    Viewing data in Microsoft BI

    Chat Widgets

    REST API

    Using SendGrid for emails

    Saving files to AWS S3 Bucket (IAM Method)

    Incoming Webhooks

    Embeddable Components

    Saving Files to Custom S3 Bucket (Account Method, Recommended)

    PDF Forms

    Stripe Checkout

    JavaScript Callbacks and Actions

    Twilio Integration

    ⚙App Settings

    General Settings

    Layout & Format Settings

    Custom Domain

    Customizing CSS

    Changing app themes

    Support Settings

    404 Error Page

    💳Account

    Plans

    Managing Your Account

    Sharing your app builder

    Managing your Apps

    🧩Pipes

    Introduction to Pipes

    Adding Pipes

    Using Pipes

    PDF Gen V2

Categories
📖 Manual
🧰 The Data Builder
Fields

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

We will explore each of these seven field type categories within the following articles. 

Adding fields

For your convenience, there are two easy ways to add fields to your data tables. 
  1. You can add fields inline within your data table by clicking on the + icon which will be located to the right of your most previously added field in Records.

Add New Field Records

        2.  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

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.

How did we do ?

Previous Article
Data Tables
Next Article
Text Fields
Article Navigation
  • What are fields‌?
  • Field Types
  • Adding fields
  • Editing fields
  • Reordering Fields
  • Changing Field Types
  • Deleting fields
  • Field Character Limitations
  • Field Quantity Limits
  • Back to top
    Developer portal Tadabase Community
    API
    100% Operational
    Apps
    100% Operational
    Builder
    100% Operational
    Overall Status
    100% Operational