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…

sleep

To force Ninox to wait for a given number of milliseconds before continue running the code With this function, you can put Ninox on hold before continuing to execute your script.…

sin

To calculate the sine The function can be used to determine the sine of a number. The result is a numeric value between -1 and 1. Syntax sin(number) Return number Examples sin(x) To calculate the…

sign

To return the signum of a number You can use the function to determine the sign of a number. The return value is either 1 (positive number) or -1 (negative number).…

shareView

To return a URL of a given view With this function, you can share a table view per script. If you don't specify the view to be shared, the default view will be selected.…

shareFile

To return a URL of a specific file Use this function to create a link to share an image or an attachment per script. The shareFile function generates a share link that is only valid within the…