Functions

Array Formula

A special function, which allows to execute a formula or an operation against a range of cells.

Authentication

Functions that allow to authenticate the user with 3rd party OAuth providers.

Cache

Functions that allow to control local cache with IndexedDB under the hood.

Cell

Functions that operate with cells and ranges.

Date and Time

Functions for calculating and parsing date and/or time data.

Drag-n-Drop

Functions providing logic to support drag-n-drop functionality.

DOM

Functions for submitting forms.

Export

Functions that export data.

Extract & Transform Data

Functions that manupilate with data, on top-level sheet, or in nested frames.

Files

Functions that can upload and save files.

Financial

Functions that get financial data from external services.

Frames

Functions that work with frames, including CRUD, JOIN and other transformations.

JSON

Functions that work with JSON, and a JsonPath adapted for nested frame structure.

Logical

Functions with logical operations.

Lookup

Functions allowing to lookup for a specified value in range.

Math

Mathematical functions.

Streaming

Functions for work with streams.

Surface

CRUD functions for surface, that can be used for dynamic form creation.

Databases and tables

Functions for work with DB. PostgreSQL is under the hood.

Testing

Functions for testing purpose.

Text

Functions for work with text.

Timer

Timer function allows to execute an action repeteatedly with a specified interval.

Web

All web-related functions: work with REST, Cookies, Decode/Encode URL, etc.