Design Tables and Choose Field Types
Design a Contacts table, choose field types, and add and update a record. Learn why the right field types make your data easier to use.
Watch tutorial (3:46)
Design a Contacts table, choose field types, and add and update a record. Learn why the right field types make your data easier to use.
Watch tutorial (3:46)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.
Summarise Records
Use Summarize Records when you need a summary rather than a list of every record. Create a summary. 1. Add Summarize Records to your workflow. 2. Choose the table and add filters if you only want some records. 3. Open Output and add a calculation. 4. Choose Count, Sum, Average, Lowest or Highest. 5....
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...
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...
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...
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...