LogoLogo
  • 👋Welcome
  • 🎓Academy
    • Getting Started
    • Connecting Data Sources
      • Jet Database
      • Google Sheet
      • Airtable
      • Custom API Action (Zapier)
      • Firebase
    • Data Editor
      • Data Editor Interface
      • Data Source Settings
      • Prepare & Organize Data
      • Edit Data
      • Field Types
      • Related Data
      • Lookups & Rollups
      • Files & Storages
      • Data Blending Intro
    • App Builder
      • Builder and User Modes
      • Pages and Overlays
      • UI Builder
      • Bind Data to UI
      • Bind Filter to Table
      • Bind Input Field to Table
      • Bind Form to Table
      • Bind Related Tables
      • Bind across Pages
      • Bind from Page to Modal
      • Calculcation & Formulas
    • Team & Users Permissions
    • Automations
    • Environments
    • Custom API Collection
    • Nested Filters
    • Built-in Approval Flow
    • Create Multi-Step Forms
    • Component Designer
    • Build Apps Together
      • Custom CRM
      • Internal Tool
      • Customer portal
      • Supabase CRM
    • Import Figma design to Jet
    • Authentication
      • Supabase Auth
      • Firebase Auth
      • Xano Auth
  • 📣What's new
  • 🔐Data Privacy & Security
  • 🙌Join the Community
  • 🐞FAQ and Troubleshooting
    • A data resource is failing to sync
    • Data is not loading
    • How to clone the whole app?
    • Why new SQL tables are not showing?
    • How to restrict input in a text field?
    • Troubleshooting Django integration
    • How to Connect to Slack Channel
  • Guides
    • ⚡Quickstart
    • 🛠️Building an Internal Tool
      • Connect your Data
      • Configure Data
      • Build UI
      • Run Actions
      • App Customization
      • Publish your App
    • 👥Creating a Customer Portal
      • Prepare your Data
      • Generate the App
      • Set the Layout
      • Link Related Tables
      • Customize your Portal
      • Users & Permissions
    • 🤿 Deep dives
      • Single relations
      • Conditional Visibility
      • Reading data from API
      • Reading data from SQL
      • Generate Invoice or Document
        • Document
    • 📧Send Emails
    • 🎨Pixel Perfect App
      • Designing your component
      • Adding Images
      • Apply Frame to Image
      • Pass values to Image
      • Pass values to Text Field
      • Binding data
      • Hide elements
      • Support multi-screens
    • 🚀UI in seconds
    • 🪅Figma design into a web app
  • AI Custom Components
    • Enhance Your Prompts with AI Assistance
    • Enhancing Your Prompts with Images
    • Auto-Generate Parameters and Actions
    • Edit Your Custom Code with the Custom Component Builder
    • Import and Iterate on Your Existing Components
  • References
    • 🦄Core concept
      • Jet UI
        • App settings
          • Appearance Settings
          • Adding Custom Fonts
          • Theme & Styles
          • Menu
          • App Info
          • Custom Domain and Transactional Emails
          • Sign Up
          • Features
          • Custom Scripts & Styles
      • Intro to Data
      • Navigation
      • Menu Conditional Enabled
      • Set Variable Action in Menu
      • Sharing your app
        • Invite by Email
        • Invite by Link
        • Creating a Public Page
    • 🧰Data Sources
      • Database resources
        • Instant Installation
        • Docker Installation
        • Python app Installation
      • Jet Tables
        • Storage & Files
      • Rest API
        • Basic Authentication
        • Bearer Token
        • OAuth 2.0
        • Jet Requests Auth
      • Firebase / Firestore
        • Syncing Firebase Data Using Functions
        • Firestore
        • Import CSV into Firebase
        • Firebase Cloud Storage
        • Realtime DB
        • Visualize Subcollection
      • Google Sheets
        • Working with Data
      • Airtable
      • MongoDB
      • Amazon Athena (AWS Athena)
      • Databricks
      • CockroachDB
      • ClickHouse
      • GraphQL
      • Supabase
      • Django
      • MySQL
      • MariaDB
      • Xano
        • Create APIs on top of your Xano database
        • Connect Xano to Jet Admin
        • Upload files to Xano
      • SmartSuite
      • Stripe
      • Hubspot
      • Intercom
      • Zendesk
      • Salesforce
      • Slack
      • Zapier
      • Webflow
      • Amazon S3 and S3 compatible storage
      • Google Cloud Storage
      • SendGrid
      • Twilio
      • Mixpanel
      • Snowflake
      • OpenAI and Jet Admin
      • Supabase Storage
    • 🔗Binding & Values
      • Binding Components
      • Extract & Pass Values
      • Binding two related Tables
      • Binding Form to Table
      • Binding Filter to Table
      • Binding Field to Table
      • Binding across Pages
      • Binding across Overlays
    • 🔠Variables
    • 🌈Basic Columns
    • 🔢Computed Column
      • Relations
      • Rollup Column
      • Lookup Column
      • Formula
        • Setting up promotional email
        • Create Custom fields using Formulas
        • Parse JSON Fields
        • Math Column
        • List of Functions
      • JavaScript Column
      • Calculated values in column
    • 🎨Design & Structure
      • Customizing Pages
        • Create a New Page
        • Copy the Page
        • Customize the Page
        • Page Values
        • Link Pages
        • Load Data (Page Query)
        • Page Opens Action
        • Home Page
      • Components
        • Lists
          • Table
            • Grouping records
            • Filters (built-in)
            • Table Actions
          • Map
          • Kanban
          • Calendar
          • Gallery
          • Carousel
          • Timeline
        • Filters
        • Form
          • Create a Form
          • Customize a Form View
          • Examples
          • Page
          • Select
          • Multiple Select
        • Fields
          • File
          • Multiselect / Chips
          • Checkbox
          • Date & Time
          • Date Range
          • Image
          • Text
          • Password
          • Number
          • Rating
          • Slider
          • Range Slider
          • Steps
          • URL
        • Charts
          • How to Set Up a Chart
            • Chart Appearance
            • Drill Down
          • Line
          • Bar
          • Pie
          • Doughnut
          • Single value
        • Text
        • Buttons
        • Button Group
        • Custom Notifications
        • Component Actions
        • Detail
        • Layouts
          • Containers
          • Accordion
          • Collapse
          • Columns
          • Overlays
            • Customizing Overlay
            • Overlay Parameters
            • Building dynamic workflows
          • Slideout
          • Tabs
          • Vertical Tabs
        • HTML Component
        • JavaScript component
          • Create a JavaScript Component
          • Set JavaScript Component Inputs
          • Use JavaScript Component Outputs
        • File PDF Viewer
        • QR Code
        • Bar Code
        • Scanner
        • Signature
        • IFrame
        • Alert
        • Accordion
        • Chips
      • Field Values
        • Extract values from components on the Page
      • Nested Filters
      • Advanced Filters
      • Sort
      • Group
      • Actions
      • Dropdown Popups
      • Export
      • App Theming
      • Global CSS & JS
      • Analytics or Live chats
    • 🧮Data Editor
      • Syncing Schema and Data
      • Managing Columns
      • Making API requests
        • Endpoint Response Outputs
        • Response Transformer
        • Sorting data
        • Pagination
          • Page-based pagination
          • Offset pagination
          • Cursor based pagination
      • Making SQL queries
      • Text to SQL
      • Storages
      • File Storage and Uploading
        • Jet Admin Storage
        • Data Source Storage
      • Cache Frequency
      • Many-to-many relationship
    • 🧞‍♂️Visibility rules
    • ℹ️Conditionals
      • Conditional Visibility
        • Examples
          • Hiding a component until a row is selected
          • Hiding a component until a row with a certain value is selected
          • Hiding a component using the Page Value, User, or Team Property value
          • Hiding a component using multiple conditions
      • Conditional Disable
      • Conditional read, add, edit & delete
    • 🔐Users & Permissions
      • Sign In/Sign Up
        • Auth0 SSO OAuth 2.0
        • Auth0 SSO SAML2
        • Azure AD SSO OAuth 2.0
        • Okta SSO
        • Google SSO OAuth 2.0
        • Google SSO SAML2
        • Custom SSO OAuth 2.0
        • API calls with SSO token
      • Roles in Permissions
      • User-specific Permissions
    • ▶️Preview & Publish
      • Embed Apps
        • Embedding App using a generated link
        • Embedding App using iFrame/HTML
    • ⚙️ Automations & Workflow
      • Triggers
      • Steps
        • Actions
        • Rules
      • Inputs, Outputs, Parameters
      • Test & Debug
      • Approval Workflow
      • Success/Error Actions
      • Iterators
      • Zapier Workflows
    • 👨‍💻Javascript
    • 💠360 Data/Data Blending
      • Sync Connection
      • Blending the Data
      • Sync Options
    • 🔤Localization
      • Account Settings
      • Adding Language to Jet Admin
      • End-user Localization
    • 🎚️Version Control
      • Cross-Instance Backup Restoration
    • 📖Logs
    • 🪂Other Features
      • Environments
        • Merge Environments: Jet Tables and Custom Components
      • Audit logs
      • Manage your subscription
      • Custom domain
      • Update to a new version
    • 🛫Jet Admin API
      • Interacting with Jet Admin API
        • Get API Token
      • Users API
      • Teams API
      • Projects API
      • Pages API
      • HTTP requests API
    • 🔐Authentication systems
      • Jet Auth
      • Firebase Auth
      • Auth0
      • Supabase Auth
      • Token-based Auth
      • Xano Auth
    • 🎇Integrations
  • 🖍️Component Designer
    • How to use pixel-perfect components
    • How to work with component designer
    • Right sidebar
      • Layout
      • Auto Layout
      • Conditional Visibility
      • Component Responsiveness / Constraints
      • Fills
      • Borders
      • Shadows
      • Interactions
    • Frames and Groups
    • Action components
    • Component and layer states
  • 🖼️Import Figma Design
    • Install Plugin
  • DEPLOYMENT
    • ⛅Cloud
    • 🏎️Self-hosted
      • SSO on self-deployed Jet Bridge
      • Using self-deployed HTTP proxy
      • Common Problems
      • Configuration
    • 🖥️On-premise
      • Deploy On-Premise Jet Admin with Docker
      • Update
      • .env configuration (local host)
        • Custom Domain Configuration on-premise
        • Email Sending Configuration
        • Nginx Configuration
      • Service Health Check
      • Common Problems
      • Superuser access
    • ⛺️ Database Heroku deployment
Powered by GitBook
On this page
  • GENERAL FUNCTIONS
  • LOGICAL FUNCTIONS
  • MATHEMATICAL FUNCTIONS

Was this helpful?

Export as PDF
  1. References
  2. Computed Column
  3. Formula

List of Functions

GENERAL FUNCTIONS

CONCAT(value1, [value2, ...]

Example: CONCAT(item.width, 'px')

Summary:

Returns the concatenation of values.

value1

The value to which value2 will be appended

value2 – optional, repeatable

The value to append to value1

FORMAT(template, [argument1, ...]

Examples:

FORMAT('{0} of {1}', item.number, data.total)

FORMAT('{} of {}', item.number, data.total)

Summary:

Returns string with arguments inserted into template placeholders.

template

Template with placeholders for arguments

argument1: – optional, repeatable

The value to insert into template placeholder

CONTAINS(object, value, [caseInsensitive])

Examples:

text

Summary:

text

value1

text

value2 – optional, repeatable

text

SIZE(value)

Example:

SIZE(item.apartments)

Summary:

Returns the number of values in a dataset

value

Dataset (array) of values

NUMBER_FORMAT(value, [format], [fraction])

Examples:

NUMBER_FORMAT(item.amount, 'metric_prefix')

NUMBER_FORMAT(item.price, 'currency', 2)

NUMBER_FORMAT(item.complete, 'percentage')

NUMBER_FORMAT(item.order, 'order')

NUMBER_FORMAT(item.size, 'file_size', 2)

NUMBER_FORMAT(item.amplitude, 'exponential', 4)

Summary:

Returns string representation of number using given format

value

Number value

format – optional

metric_prefix, currency, percentage, order, file_size, or exponential

fraction - optional

Max fractional part, default is 2

EMPTY(value)

Example:

EMPTY(item.apartments)

Summary:

Returns if the value is empty

value

Dataset (array) of values or string

GET(object, property, default_value)

Examples:

GET(record, 'first_name', 'no name')

Summary:

Returns property from object

object

Object with properties

property

Property name you want to extract

default_value

Value that will be returned if property not found

ANY(value1, [value2, ...])

Example:

ANY(item.title1, item.title2)

Summary:

Returns first value which is not empty, null or undefined

value1

The first value to return from

value2 – optional, repeatable

Additional values to return from

STRING(value)

Example:

STRING(12.34)

Summary:

Returns value as string

value

Any value that needs to be transformed to a string

NUMBER(value)

Example:

NUMBER('12.34')

Summary:

Returns value as number

value

Any value that needs to be transformed to a string

JSON(value)

Example:

JSON('{"foo":"bar"}')

Summary:

Returns JSON string value as object to extract data

value

JSON formatted string

IS_NULL(value)

Example:

IS_NULL(item.address)

Summary:

Returns if the value is NULL

value

Any value type

UUID()

Example:

UUID()

Summary:

Returns a random UUID unique identifier

HASH(length)

Example:

HASH(32)

Summary:

Returns a random hash with the specified length

length

The length of the hash

RANDOM(low, high)

Example:

RANDOM(1, 10)

Summary:

Returns a uniformly random integer between two values, inclusive

low

The low end of the random range

high

The high end of the random range

MAP(value, func)

Example:

func(x) = {"foo": x}; MAP([4, 3, 1, 5], func)

Summary:

Mapped database {array} using provided function

value

The dataset to be mapped

func

Function for mapping 1 item

FILTER(value, func)

Example:

func(x) = x >= 2; FILTER([4, 3, 1, 5], func)

Summary:

Filtered dataset (array) using provided function

value

The dataset to be filtered

func

Function for filtering 1 item

UPPER(value)

Example:

UPPER('English')

Summary:

Returns value in uppercase

value

A string that needs to be converted to uppercase

LOWER(value)

Example:

LOWER('English')

Summary:

Returns value in lowercase

value

A string that needs to be converted to lowercase

TITLE_CASE(value)

Example:

TITLE_CASE('English')

Summary:

Returns value in titlecase

value

A string that needs to be converted to titlecase

SLUGIFY(value, [separator])

Examples:

SLUGIFY('Top 10 places to visit')

SLUGIFY('Top 10 places to visit', '-')

Summary:

Returns value as human-readable keywords

value

Any value that needs to be transformed to a slug

separator – optional

Symbol which separates words

LOGICAL FUNCTIONS

IF(logical_expression, value_if_true, value_if_false)

Example:

IF(item.approved, 'Approved', 'Not approved')

Summary:

Returns one value if a logical expression is TRUE and another if it is FALSE

logical_expression

An expression or variable containing an expression that represents some logical value, i.e. TRUE or FALSE, or an expression that can be coerced to a logical value

value_if_true

The value the function returns if logical expression is TRUE

value_if_false

The value the function returns if logical_expression is FALSE

EQ(value1, value2)

Example:

EQ(1, 2)

Summary:

Returns TRUE if two specified values are equal and FALSE otherwise

value1

The first value

value2

The value to test against value1 for equality

AND(logical_expression1, logical_expression2)

Example:

AND(item.approved, NOT(item.processed))

Summary:

Returns TRUE if all of the provided arguments are logically true, and FALSE if any of the provided arguments are logically false

logical_expression1

An expression or variable containing an expression that represents some logical value, i.e. TRUE or FALSE, or an expression that can be coerced to a logical value

logical_expression2

More expressions that represent logical values

NOT(logical_expression)

Example:

NOT(item.processed)

Summary:

Returns the opposite of a logical value - NOT(TRUE) returns FALSE, NOT(FALSE) returns TRUE

logical_expression

An expression or variable holding an expression that represents some logical value

OR(logical_expression1, logical_expression2)

XOR(logical_expression1, logical_expression2)

Example:

XOR(item.approved, item.processed)

Summary:

Returns TRUE if an odd number of the provided arguments are logically true and FALSE, if an even number of the arguments are logically true

logical_expression1

An expression or variable containing an expression that represents some logical value, i.e. TRUE or FALSE, or an expression that can be coerced to a logical value

logical_expression2 – repeatable

More expressions that represent logical values

MATHEMATICAL FUNCTIONS

ROUND(value, [places])

Examples:

ROUND(2, 35)

ROUND(2, 35, 1)

Summary:

Rounds a number to a certain number of decimal places according to standard rules

value

The value to round to places number of places

places - optional

The number of decimal places to which to round

CEIL(value, [factor])

Examples:

CEIL(2.26)

CEIL(2.26, 0.01)

Summary:

Rounds a number up to the nearest integer multiple of specified significance factor

value1

The value to round up to the nearest integer multiple of factor

factor – optional

The number to the multiples of which the value will be rounded

FLOOR(value, [factor])

Examples:

FLOOR(2.56)

FLOOR(2.56, 0.1)

Summary:

Rounds a number down to the nearest integer multiple of specified significance factor

value

The value to round down to the nearest integer multiple of factor

factor – optional

The number to the multiples of which the value will be rounded

POW(base, exponent)

Example:

POW(2, item.length)

Summary:

Returns a number raised to a power

base

The number to raise to the exponent power

exponent

The exponent to raise the base to

LOG(value, [base])

Example:

LOG(8, 2)

Summary:

Returns the logarithm of a number with respect to a base

value

The value for which to calculate the logarithm

base - optional

The base to use for the calculation of the logarithm, default is 10

EXP(exponent)

Example:

EXP(8)

Summary:

Returns Euler's number, e (-2.718) raised to a power

exponent

the exponent to raise e to

ABS(value)

Example:

ABS(-3)

Summary:

Returns the absolute value of a number

value

The number of which to return the absolute value

SQRT(value)

Example:

SQRT(16)

Summary:

Returns the positive square root of a positive number

value

The number for which to calculate the positive square root

FIX(number, places)

Example:

FIX(3.14159265, 2)

Summary:

Formats a number with a fixed number of decimal places

number

The number to format

places

The number of decimal places to display in the result

MIN(value1, [value2, ...])

Example:

MIN(item.discount, 0.15)

Summary:

Returns the minimum value in a numeric dataset

value1

The first value or range to consider when calculating the minimum value

value2 – optional, repeatable

Additional values or ranges to consider when calculating the minimum value

MAX(value1, [value2, ...])

Example:

MAX(item.events, 9999)

Summary:

Returns the maximum value in a numeric dataset

value1

The first value or range to consider when calculating the maximum value

value2 – optional, repeatable

Additional values or ranges to consider when calculating the maximum value

AVERAGE(value1, [value2, ...])

Example:

AVERAGE(item.morning, item.afternoon, item.evening)

Summary:

Returns the numerical average value of a dataset, ignoring text

value1

The first value or range to consider when calculating the average value

value2 – optional, repeatable

Additional values or ranges to consider when calculating the average value

SUM(value1, [value2, ...])

Example:

SUM(item.sold, item.reserved)

Summary:

Returns the sum of numbers

value1

The first number to add

value2 – optional, repeatable

Additional numbers to add to value1

There are also Date & Time functions and Permission functions.

PreviousMath ColumnNextJavaScript Column

Last updated 1 year ago

Was this helpful?

🔢