Sign Up

Table Field Types

Each table column in Twidget has a data type. The available data types are:

  • Text

  • Number

  • Boolean

  • Date

  • Object

Field Type Adherence

Data added to the table should adhere to the column's field type. When you manually enter data via the web application, the value editor will use the input type of the field.

Field Types

Text

  • Description: Allows alphanumeric characters.

  • Example: "Sample Text", "1234", "Hello World!"

Number

  • Description: Allows numeric values.

  • Example: 125, 0.45, -20

Boolean

  • Description: Represents true or false values.

  • Example: true, false

Date

  • Description: Allows date values following a specific format.

  • Example: "2023-10-01", "2022-12-31"

Object

  • Description: A complex type that can have any data type for its fields.

    • Fields within an object can adhere to the types mentioned above.

Single vs Multiple Values

Each field can hold either a single value or multiple values. You can enable a field to store multiple values by selecting the "List" option in the field creator.

Managing Table Fields

Adding New Fields

To add a new field to your table:

  1. Click the "+" icon.

  2. Choose the field type and name your field.

  3. Configure any additional settings (e.g., enable multiple values).

Editing Existing Fields

To edit an existing field:

  1. Locate the field you want to edit.

  2. Click on the field name.

  3. Make the necessary changes and save.

Removing Fields

To remove an existing field:

  1. Locate the field you want to remove.

  2. Click on the field name.

  3. In the Edit field sidebar click Delete.

  4. Confirm your action.

Best Practices

  • Always ensure data input adheres to the specified field type.

  • Use meaningful names for your columns to facilitate easy understanding and management.

  • Regularly review and update fields to keep your data structure optimized.

Related Topics

Table Relationships

In Twidget, you can connect database table data using the `_id` field that is automatically generated for every row in a table. This `_id` field is essential for creating and maintaining relationships across different tables. Types of Relationships. A one-to-one relationship occurs when a single row...

Filter Data

In Twidget, you can easily filter and sort data within the database tables view. This allows you to refine and manipulate the data as needed. Below are the steps and options available for filtering and sorting data. Filtering Data. To filter data: 1. Click on the Filter Button: In the table toolbar,...

Export Data from Tables

Twidget allows you to export data from your database tables to a CSV file. This feature supports the export of both complete and filtered datasets. Here’s how you can utilize this functionality: Features. - Format: Export data in CSV format. - Data Handling: Object and list data types within your ta...

Adding Database Table Rows

In Twidget, you can easily add new entries (rows) to your database tables. This feature allows you to expand your data dynamically without the need for complex coding. This document provides a step-by-step guide on how to add rows to your database tables. Adding a New Entry to a Table. To add a new ...

Database Storage

Managing your database storage effectively is crucial for ensuring optimal performance and cost-efficiency when using Twidget. Each entry within your database table utilizes a certain amount of storage space. Twidget provides intuitive tools to help you monitor and manage this storage. Viewing Datab...