Manage data type
Explore the list of data type available for data of a native Alloy table, seeing the powerful control you have over the data.
Metadata Columns
Metadata columns are default fields in a database or data structure that store information about the data itself, rather than the actual content of the data.
These columns provide details about how, when, and by whom the data was created, modified, or accessed, helping to manage and audit the data over time.
Created At
The date and time when the record was initially created.
Date
Created By
The user that initially created the record.
User Column
Last Updated At
The date and time when the record was last modified.
Date
Last Updated By
The userthat last modified the record.
User Column
User column
The User column type is designed to store information related to users within a system.
The data set for this Column is the records of all users of your app.
Textual Data Types
Single line text
A short piece of text, used for brief information like names.
"John Doe"
Long text
A longer piece of text for detailed descriptions or comments.
"This is a detailed description of the product..."
Identification Data Types
A string that follows the email format, used for contact information.
"john.doe@example.com"
Phone number
A string representing a telephone number, used for contact details.
"+1-234-567-8900"
Barcode
A numeric or alphanumeric string used to identify products.
"012345678905"
Address
A string representing a physical location, used for mailing or billing addresses.
"123 Main St, Anytown, USA"
Numerical Data Types
Number
A numeric value, used for quantities or measurements.
"12345"
Currency
A numeric value representing money, often with a currency symbol, used for financial transactions.
"$100.00"
Boolean Data Types
Checkbox
A boolean value indicating a true/false condition, used for status or selection.
"Checked" or "Unchecked"
Date & Time Data Types
Date
A value representing a calendar date, used for scheduling or recording events.
"2024-07-23"
Media Data Types
Photo
An image file, used for visual representation.
"image.jpg"
File
Any type of file, used for attachments or documents.
"document.pdf"
Option Data Types
Single select
A value chosen from a predefined list of options, used for categorization.
"Option A"
Multi select
Multiple values chosen from a predefined list of options, used for categorization.
"Option A, Option B"
Relational Data Types
Virtual column
A calculated field or a reference to other data, values is computed using PowerFx
Thisitem.quantity*Thisitem.price
Link to another table column
A reference to another table, having the records from the table as the option set for input value.
Column "Assignee" links to table "Staff", having selection of staffs as the input value.
Lookup
A reference to a column in the linked table, showing the field's value of the records chosen.
Column "Position" links to column "Position" of linked table "Staff", showing the position of "Assignee" when a persion is chosen in the column "Assignee".
Last updated