Twidget offers a comprehensive database solution for all workspaces. Here's an overview of how databases are structured and managed within Twidget:
-
Tables: A database may contain multiple tables. Each table stores data in a structured format.
Fields: Tables consist of fields that you can add or remove according to your needs.
Data Types: Each field has a datatype that dictates the type of data it can store. The available datatypes are:
Text
Number
Boolean
Date
Object
List Data: Fields can also hold lists of data if specified.
Rows: Data is stored in rows within a table. Each row represents an individual data entry.
Manual Editing: You can manually edit the data via the web application or through no code commands provided by Twidget.
Deletion: Be cautious when deleting data as deletion actions are irreversible. Once data is deleted, it cannot be restored.
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...
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 Tables
Database tables are essential components of your Twidget workspace, serving as the primary storage locations for your data. In Twidget, each table consists of rows and fields, meticulously designed for efficient data management and retrieval. Structure of Database Tables. - Rows: Each row in a datab...
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...
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,...
