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)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.
Rows: Each row in a database table represents a single data entry or record.
Fields: Fields are the individual columns in a table that store specific types of data. Each field has a designated datatype, and the data stored within must conform to this datatype.
Datatypes: Each field in a table is assigned a datatype, which dictates the kind of data that can be stored in that field (e.g., text, number, date).
System-Generated Fields: Each entry in a table automatically includes a unique identifier (_id) and a timestamp (created_at) indicating when the entry was created.
Twidget provides robust features for managing your database tables:
Edit Table: You can modify the structure of your table by adding or removing fields as needed.
Manage Data: Manage the entries in your table effortlessly with tools for editing, deleting, and viewing records.
View Data Usage: Monitor your table’s data usage statistics via the tables toolbar located at the top of the page.
Import and Export: Easily import data into your table or export it for external use.
Filter and Sort: Utilize the filter and sort tools to refine the data displayed in your table according to specific criteria.
Database tables in Twidget are powerful and flexible, allowing you to efficiently store, manage, and interact with your data. From automatic system fields to comprehensive data operations and authentication functionalities, Twidget tables provide a robust framework for your no-code applications.
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...
Database Change Triggers
Run an event automatically when a record is created, updated or deleted in a Twidget table. For example, send a welcome message after adding a customer, or refresh a summary when an order changes. Prepare the event. Create an event containing the steps you want to run. Add an Object input named `tri...
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...
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....
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,...