All topics

teamId

To return the ID of the current workspace This function returns the ID of the workspace you are in. You might need this in your REST API. Syntax teamId() Return string Examples teamId() Result:…

tan

To calculate the tangent The function returns the tangent of an angle. Syntax tan(number) Return number Examples tan(x) To calculate the tangent of a number x. tan(1) Result: 1.5574077246549023 tan(1.…

tableId

To return the ID of a table With this function, you'll find out the internal identifier of the current table. This ID consists of at least 1 capital letter. It starts with A.…

sum

To return the total sum of a number array With the function, you can calculate the mathematical sum of numeric values from an array or a table. For example,…

substring

To return a new string out of a given text with a given start and a given end This function extracts a part of a text according to your specifications. You need to provide the start position,…

substr

To return a new string out of a given text This function extracts a part of a text according to your specifications. You need to provide the start position,…

styled

To convert a given string to a styled object With this function, you can style a formula field with colors (for example the background) but also with an additional icon.…

Functions—alphabetically

Web integration and API

An overview of functions to connect your databases to external services and think outside the box createCalendarEvent To create an event in the Apple Calendar App createCalendarReminder To create a…

User management

An overview of all user management related functions clientLang To return the currently used language of the browser or app in abbreviated form isAdminMode To return Yes (true) if the edit mode is on…

User interface

An overview of the functions related to your user interface alert To open a pop-up with an alert message barcodeScan To open the barcode scanner and return the scanned value as a string…

Text

An overview of text-related functions capitalize To capitalize the first letter of each word chosen To return Yes (true) if the given value equals a given selection concat To return all items of an…

Mathematical

An overview of mathematical functions to perform tasks on numbers abs To return the absolute value of a number acos To calculate the arccosine asin To calculate the arcsine atan To calculate the…

Format and convert data

An overview of functions to help you format and convert data types appointment To convert given time-related values to an appointment array To create a new array by merging 2 arrays of a similar type…

Files and printing

An overview of functions to help you to manage files and printing appendTempFile To create a temporary file on the Ninox server createTempFile To add content to a temporary file on the Ninox server…

Date and time

An overview of date- and time-related functions age To return the number of full years between now and a given date (e.g. a person’s age) appointment To convert given time-related values to an…

Database operations

cached To run a given script only once and cache and return the output value closeAllRecords To close all record forms closeFullscreen To close full-screen mode closeRecord To close the top record…

Array

An overview of the array functions array To create a new array by merging 2 arrays of a similar type avg To return the average of a number array chosen To return Yes (true) if the given value equals…

Functions—by category

Functions overview

See all Ninox functions at a glance. Each feature is linked to a separate page. abs To return the absolute value of a number acos To calculate the arccosine age To return the number of full years…