An authentication table is a crucial component in Twidget that is used to store all necessary authentication information, essential for authenticating requests.
Purpose: To store authentication details such as email, password, token signature, and reset key.
Recommendation: It's recommended to use a users table for this purpose.
Use Data → Authentication to search the table's customers, suspend or resume access and manage independent sessions. See Customer authentication tools for the commands, login compatibility and session limits. These controls use this same table.
Mandatory for Endpoints: An authentication table is necessary for generating authentication endpoints.
Unique to Workspace: You can assign only one authentication table per workspace.
When creating a new table, you have an option to designate it as the authentication table:
You can also update an existing table to become an authentication table by adjusting its settings in the table configuration.
When you generate authentication endpoints, the following fields are automatically created in the authentication table:
email: Stores user email addresses.
password: Stores user passwords in a hashed format for security.
token_signature: Stores token signatures as hashed values for added security.
reset_key: Stores reset keys in a hashed format for password reset operations.
In the database view:
To summarize, the authentication table in Twidget:
Stores critical authentication data.
Is a prerequisite for generating authentication endpoints.
Introduces security features by hashing sensitive information.
Can be easily identified and configured within the workspace.
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,...
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...
Save Changes Together
A Database Transaction groups database work so its changes complete together. If a command in the block fails, the block's changes are rolled back. Example: an order and its stock change. 1. Add Database Transaction to the workflow. 2. Inside Save changes together, add the supported commands that cr...
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...
