AppAlloy Documentation
Home
  • Glossary
  • 🚀Getting Started
    • Introduce AppAlloy Documentation
    • Build your first AppAlloy app
    • From sheet to app
  • 🗃️Data management
    • Learn data structure
    • Set up data source
      • Integrate with Google Sheets
      • Integrate with Microsoft Excel
      • Build Alloy table
      • Upload local file
    • Manage data type
    • Ultimate guide for data sheet
  • ⚒️Manage table views
    • Design Record View
    • Design Actions
      • Update current record
      • Delete current record
      • Delete many records
      • Create record
      • Open external URL
      • HTTP Request
      • Open phone call popup
      • Open SMS Popup
      • Open email popup
      • Send notification
    • Design Record Components
      • Plain Text
      • Phone number
      • Email
      • URL
      • Map
      • Barcode
      • Checkbox
      • Number
      • Currency
      • Rating
      • Voting
      • Date time
      • Relative date
      • Count Down / Count Up
      • Single Photo
      • Photo Gallery
      • Carousel
      • Audio Player
      • Video Player
      • Youtube Player
      • Vimeo Player
    • Design Form View
    • Design Form fields (synced tables)
      • Text (for synced tables)
      • Number (for synced tables)
      • Date time (for synced tables)
      • Checkbox (for synced table)
      • Options (for synced table)
      • Photos (for synced table)
      • Files (for synced table)
      • Table lookup (for synced table)
      • Signature (for synced table)
    • Design Form fields (Alloy tables)
      • Single line Text (for Alloy table)
      • Long Text (for Alloy table)
      • Phone number (for Alloy table)
      • Email (for Alloy table)
      • Barcode (for Alloy table)
      • Number (for Alloy table)
      • Currency (for Alloy table)
      • Checkbox (for Alloy table)
      • Date (for Alloy table)
      • Photos (for Alloy table)
      • Files (for Alloy table)
      • Single select (for Alloy table)
      • Multiple select (for Alloy table)
      • Address (for Alloy table)
      • Table lookup (for Alloy table)
  • 🎨Manage pages
    • Manage page types
    • Design 'View From' Page
    • Page Layouts
      • List Layout
      • Grid Layout
      • Card Layout
      • Map Layout
      • Checklist Layout
      • Calendar Layout
      • Kanban Layout
    • Design Canvas View Page
    • Canvas Charts
      • Line chart
      • Area Chart
      • Pie Chart
      • Donut Chart
      • Column chart vs. Stacked Column chart
      • Bar chart vs. Stacked bar chart
      • Table
    • Design Form of... Page
  • ⚙️Manage workflow
    • Introduce Workflow
    • Design a workflow
  • 🔌Manage Integration
    • Manage AppAlloy Integration
    • Manage Slack Integration
    • Manage Gmail Integration
    • Manage Google Drive Integration
    • Manage Google Calendar integration
  • 📱Manage App Settings
    • Manage app appearance
  • 🌎App distribution
    • Publish your app
    • Use app as Mobile Web app
    • Use app on AppAlloy Air
  • 🚹Account, team, and plan
    • Manage Account
    • Manage Apps
    • Manage Users
    • Manage Plans
    • Manage Teams
  • #️⃣Learn Power FX
    • Introduce Power FX
    • Operators & Identifiers
    • Formula References
      • Average
      • Concatenate
      • Date
      • DateAdd
      • DateDiff
      • DateValue
      • DateTimeValue
      • Day
      • If
      • Month
      • Now
      • Rand
      • RandBetween
      • Round
      • RoundDown
      • RoundUp
      • Sum
      • Text
      • Today
      • Weeknum
      • Weekday
      • Year
Powered by GitBook
On this page
  • Metadata Columns
  • User column
  • Textual Data Types
  • Identification Data Types
  • Numerical Data Types
  • Boolean Data Types
  • Date & Time Data Types
  • Media Data Types
  • Option Data Types
  • Relational Data Types

Was this helpful?

  1. Data management

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.

Column Name
Description
Type

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

Data type
Definition
Example

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

Data type
Definition
Example

Email

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

Data type
Definition
Example

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

Data type
Definition
Example

Checkbox

A boolean value indicating a true/false condition, used for status or selection.

"Checked" or "Unchecked"

Date & Time Data Types

Data type
Definition
Example

Date

A value representing a calendar date, used for scheduling or recording events.

"2024-07-23"

Media Data Types

Data type
Definition
Example

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

Data type
Definition
Example

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

Data type
Defitnition
Example

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 7 months ago

Was this helpful?

🗃️