Documentation
AcademyCommunitySign In
  • 👋Overview
  • 💙Platform Features
  • Getting started
    • 🚪Signing up & Logging in
      • 👤Profile Settings
    • 🎛️App Management
    • ✴️Templates to Start With
      • Basic Template (Blank app)
      • CRM Template
    • 👨‍🎓Learning Directual
      • 👨‍🏫Webinars
  • Data base
    • Data Structures
      • System Structures
    • Data Types
      • Markdown Cheat Sheet
      • Indexing Fields
      • Formatting Date/Time
    • Directual Query Language (DQL)
    • Import and Export
      • Import API
    • File Storage
      • API for File Storage
  • API and integraions
    • API-Endpoints
      • Advanced techniques for GET and POST requesting
        • Paging for GET-requests
        • Dynamic sorting for GET-requests
        • Custom filtering parameters for GET-requests
        • Advanced filtering for GET-requests
        • Formatting response for GET-request
        • Fields validation for POST-requests
        • Synchronic scenarios for POST-requests
        • Cross-Origin Resource Sharing CORS
      • API testing and debugging
      • Coding mode (raw mode) in filters
      • Swagger specification
    • Webhooks
    • Authentication API
      • Login/password
      • OpenID connect
      • Facebook oAuth
      • Google oAuth
    • Security Features
    • Other Integrations
      • OpenAI
      • Integration Hubs
        • Zapier
      • Telegram
        • Telegram: Advanced Techniques
      • Email
        • SMTP
        • Gmail
      • Twilio SMS
      • Airtable
      • Coupler.io
      • Other No-Code Tools
        • Bubble.io
          • Authorization
          • Displaying Data from Directual on Bubble
        • Adalo
        • UI bakery
        • Tilda
        • AppGyver
  • App interface
    • Web-App Builder basics
    • Web-App Settings
      • General web-app settings
      • Main menu
      • Creating a logotype
      • Web-App color scheme
      • Web-app typography
      • White Labeling
      • Web-App Icon
      • Custom Domain
      • Custom code
    • Setting Up Page Layout
      • Subpages and URL Parameters
    • Components
      • Multistep Form
      • Cards
      • Table
      • Kanban
      • Chart
      • Markdown text
      • HTML code
      • Hint
      • Link Button
      • Video
      • Form (outdated)
    • Embedding Pages
  • Scenarios
    • Understanding Directual Scenarios
      • Directual Event Model
    • Event-Based Triggers
    • Scheduled Triggers
      • Cron Format
    • Synchronous Scenarios
    • Editing Scenarios
      • System Steps
        • Start step
        • Delay step
        • Comment step
        • Catch error step
        • Link scenario step
        • Exit step
      • Action steps
        • Edit object step
        • Create object step
        • Search objects step
        • JSON step
        • Delete object step
        • Run report step
        • Generate document step
        • JS SDK step
      • Condition steps
        • Condition step
        • A/B test step
        • JS SDK condition step
      • Integration steps
        • HTTP-request step
        • Zapier step
        • Telegram step
        • API response
        • Email step
        • SQL-request step
        • Queue step
    • Using Variables
      • Global Variables
      • Context Variables (scenario parameters)
    • Testing and Debugging
    • System Scenarios
    • Advanced Scenario Settings
  • Template system
    • Templating Principles
      • Templating Techniques for Scenarios
      • Templating Techniques for Web-pages
    • Coding Mode (evaluating as a JS-expression)
    • Comparison Component
      • Regular Expressions
    • Tips for Dealing with Data
  • Telegram
    • Telegram
  • Plugins
    • 🔌Using Plugins
      • Scenario Steps Plugins
      • Web Plugins
      • User Authentication Plugins (Not Web3)
        • TMA (Telegram Mini App)
        • Google OAuth Plugin
        • Facebook OAuth Plugin
        • Open ID Auth Plugin
      • Blockchain (Web3)
        • TON (The Open Network)
        • Polygon
        • Ethereum
        • NEAR Protocol
        • NFT and Smart-Contracts
        • MetaMask Wallet
        • WalletConnect
      • WebSockets (Socket.IO)
    • 🪚Developing Plugins
      • Developing Scenario Plugins
      • Developing Web-plugins
        • Example: Using Chart.js in Directual
        • Example: Building Simple Form
        • Example: TON plugin
  • Teams
    • Teams
    • Sandbox Apps
  • JavaScript SDK
    • Directual + JavaScript SDK: The Basics
    • Internal $D Methods
    • Using Google Sheets
    • JS SDK: Examples
  • Reports
    • Reports
  • App life cycle management
    • App Versions
  • Directual 💙 React JS
    • Directual + React JS
  • Pricing and billing
    • 💳How Billing Works
    • 🎁Promo Codes
    • Pricing Plans for Apps
    • Team Pricing Plans
    • How we count requests and operations
    • On-Demand Resource Consumption
    • 🤝Affiliate Program
  • Hire a Directual expert
    • 🏆Certification
    • 🤝Matching with Experts
    • 🏦Escrow service
  • Security and stability
    • 🛡️Public Cloud
    • Platform Architecture
  • Support
    • 📬Contact Directual
  • Directual step-by-step
    • Public Development Roadmap
      • Step 0: Planning App Architecture
      • Step 1: Requesting Features
      • Step 2: Approving Features
      • Step 3. Upvoting Features
      • Step 4. Watching Features
    • Weather Forecast App
    • Web3 Marketplace on Polygon
    • Transferring NFT
Powered by GitBook
On this page

Was this helpful?

  1. Data base

Data Types

Available data types

There are general types like 'string,' subtypes such as 'email,' and formatting options for some data types.

Type
Subtype
Formatting options
Description

Type

Subtype

Formatting options

Description

string

—

—

A sequence of characters used to represent text.

// Example:

Hello world!

string

markdown

—

string

html

—

Formatted HTML text

string

email

—

Formatted email address

// Example:

support@directual.com

string

phone

—

String of numbers

// Example:

79201231212

string

color

—

HEX color

// Example:

#AAA012

string

webLink

—

A URL

// Example:

http://directual.com

string

youTube

—

Youtube URL

// Example: https://www.youtube.com/watch?v=m4U232MuTG4

number

—

—

A numeric data type from –9223372036854775808 to 9223372036854775807.

// Examples:

42

-102

0

number

positiveNum

—

A positive number

decimal

—

—

An exact numeric data type. Directual interface displays up to 15 digits.

// Examples:

0.12

-99999999.9999999999

234.23123454

Supports up to 34 digits without any loss and exponent range from –6143 to +6144

Array

—

—

An array is an ordered collection of elements. Each element has its own type.

// Examples:

1,a,hello world,4,true

42.2,{"key1":true,"key2":"hello"},abc

Date

—

Date and time. By default has date-time format: YYYY-MM-DDTHH:mm:ss.sssZ)

Also can be processed as timestamp, which represents the time, in milliseconds since 00:00:00 UTC on 1 January 1970.

// Examples:

2019-10-01T10:00:00.000Z = 01 October 2019 10:00:00 in date-time format;

1569924000000 = 01 October 2019 10:00:00 in timestamp format;

Boolean

—

Options names (true and false by default)

The type for yes or no. There are three options for its value: true, false, null

JSON

—

—

JavaScript object notation. Often used in integrations. MDN Documentation.

// Example:

{

"title": "War and peace",

"year": 1865, "Chapters": [1,2,3,4,5,6],

author: {

"name: "Leo",

"last_name": "Tolstoy"

},

"is_favourite": false

}

JSON

checkboxes

Checkbox options + custom option

// JSON example:

{ "option2": true, "customOption": "2021-01-06T00:00:00.000Z" }

JSON

radioOptions

Radio options + custom option

// JSON example:

{ "value": "hello" }

or

{ "customOption": "hello world" }

JSON

slider

Unit name + step + min, max values

// JSON example:

{ "firstValue": 3 }

JSON

rangeSlider

Unit name + step + min, max values

// JSON example:

{ "secondValue": 6, "firstValue": 3 }

JSON

geo-data

Array of objects, that include coordinates, title, image (link) and a description

// JSON example

Link

—

—

The ID of an object from the linked structure.

arrayLink

—

—

Array of Links

File

—

—

File

image

—

= String, the URL of the image (PNG, SVG, JPG, BMP).

File

multipleImages

—

= String, the URLs of images, comma separated.

File

multipleFiles

—

= String, the URLs of files, comma separated.

Operator

—

// Examples:

>

<=

like

isEmpty

PreviousSystem StructuresNextMarkdown Cheat Sheet

Last updated 1 year ago

Was this helpful?

Formatted text (see )

= String, the URL of the file. Here the structure is often used.

Comparison operator from .

markdown cheatsheet
Formatting date format
fileUpload
the list