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.
To add a new entry to your database table, follow these steps:
Navigate to Your Table: First, ensure that you are viewing the relevant database table to which you want to add a new row.
Click the "Add new entry" Button:
Locate the "Add new entry" button at the bottom of the table.
Click this button to create a new row.
Populate the New Entry:
Once you click the button, a new row with null values will appear in your table.
The _id and created_at fields will already be populated
You can now fill in the necessary data for each field in that row.
The process of adding new entries to lists and objects follows a similar approach:
Navigate to the List/Object: Open the list or object where you want to add a new entry.
Click "Add new entry":
Find the "Add new entry" button within the list or object view.
Click the button to add a new entry.
Fill in the Data:
A new entry with null values will be created.
Enter the required information for the new entry.
Adding new entries to tables, lists, and objects in Twidget is straightforward and user-friendly. By clicking the "Add new entry" button and filling out the fields, you can swiftly expand your data as needed.
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 Field Types
Each table column in Twidget has a data type. The available data types are: - Text - Number - Boolean - Date - Object Field Type Adherence. 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...
External Database Connections
Read records from an existing external database without copying all of its data into Twidget. Add a connection. 1. Select your workspace and open Settings → Database Connections. 2. Select Add database connection. 3. Choose the provider: PostgreSQL, MySQL, SQL Server or Snowflake. 4. Enter a connect...
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...
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...
