Each table column in Twidget has a data type. The available data types are:
Text
Number
Boolean
Date
Object
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.
Description: Allows alphanumeric characters.
Example: "Sample Text", "1234", "Hello World!"
Description: Allows numeric values.
Example: 125, 0.45, -20
Description: Represents true or false values.
Example: true, false
Description: Allows date values following a specific format.
Example: "2023-10-01", "2022-12-31"
Description: A complex type that can have any data type for its fields.
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.
To add a new field to your table:
Click the "+" icon.
Choose the field type and name your field.
Configure any additional settings (e.g., enable multiple values).
To edit an existing field:
Locate the field you want to edit.
Click on the field name.
Make the necessary changes and save.
To remove an existing field:
Locate the field you want to remove.
Click on the field name.
In the Edit field sidebar click Delete.
Confirm your action.
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.
Authentication Table
An authentication table is a crucial component in Twidget that is used to store all necessary authentication information, essential for authenticating requests. Overview. - Purpose: To store authentication details such as email, password, token signature, and reset key. - Recommendation: It's recomm...
Database Basics
Twidget offers a comprehensive database solution for all workspaces. Here's an overview of how databases are structured and managed within Twidget: Database Structure. 1. Tables: A database may contain multiple tables. Each table stores data in a structured format. 2. Fields: Tables consist of field...
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: ...
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...
Generate CRUD Endpoints
With Twidget, you can efficiently generate CRUD (Create, Read, Update, Delete) endpoints for your database tables upon their creation. This functionality is designed to streamline the development process and ensure that essential API operations are readily available. Enabling CRUD Endpoints. 1. Crea...