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…

string

To convert a given value to a string This function will return the data of a field or an array as text. It’s a bit like the function concat(). If you use this function on a multiple-choice field,…

start

To return the start timestamp of a given appointment With this function, you can address the start of an appointment. The function will return the date + time of the appointment,…

sqrt

To calculate the square root Use the function to find the square root of a positive number. If the number has a negative sign, use the function abs() for example to convert it to a positive number…

sqr

To calculate the square The function squares a number, i.e. multiplies it by itself. The result is always positive. Syntax sqr(number) Return number Examples sqr(x) To calculate the square of a…

splitx

To split a string into an array by using a regular expression This function will split a string into single components using a regular expression. These components are assembled into an array.…

split

To split a string into an array at each separator This function will split a string into single components. These components are assembled into an array.…

sort

To sort values in ascending order This function helps you to sort values in ascending order. You can pass any number of parameters. Requirement: They have the same data type.…

slice

To extract a subrange from a string or array This function helps you to extract a partial range of an array and transfer it to a new array. You define the part you want to extract by a start and an…