Explore the database, its tables and the role of authentication tables.
Recorded with an earlier Twidget interface. Names, control locations and available options may differ; use the linked documentation for current guidance.
Watch tutorial (4:12)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.
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,...
CSV Import
Twidget enables seamless import of data from a CSV file into your database. Follow the steps below to successfully import a CSV file. Step-by-Step Guide. 1. Initiate the Import: - Click on the Import button within the table toolbar. - Select Import from CSV from the dropdown. 2. Open Import Dialog: ...
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...
Save Changes Together
A Database Transaction groups database work so its changes complete together. If a command in the block fails, the block's changes are rolled back. Example: an order and its stock change. 1. Add Database Transaction to the workflow. 2. Inside Save changes together, add the supported commands that cr...
Database Indexes
Indexes help Twidget find records quickly. A unique index also prevents duplicate values from being saved. Choose the right index. Use a lookup index for a field you regularly filter or sort, such as an order date. Use a unique index when a value must not appear twice, such as a membership number. A...
