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:
-
Format: Export data in CSV format.
Data Handling: Object and list data types within your tables are automatically converted into JSON format in the CSV file.
Filter Options: Export either all records in your database table or only the filtered results according to your specific criteria.
Navigate to the Table: Go to the database table from which you wish to export data.
Initiate Export: Click on the export button/icon.
Select Export Type: Choose the option to export all records.
Download CSV: Your CSV file will be generated and available for download.
Apply Filters: Set the specific filters on your table to narrow down the data you want to export.
Initiate Export: Click on the export button/icon.
Select Export Type: Choose the option to export the filtered results.
Download CSV: Your CSV file containing only the filtered data will be generated and available for download.
The CSV format is currently the only supported export format.
Object and list data within any column will be serialized into JSON strings within their respective cells in the CSV file.
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...
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...
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...
Adding Database Table Rows
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. Adding a New Entry to a Table. To add a new ...
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...
