-
abs
To return the absolute value of a number The function removes existing signs and returns the absolute, positive value of a number. It happens rather rarely, but for certain calculations,…
-
acos
To calculate the arccosine The function returns the arccosine of a number. Syntax acos(number) Return number Example acos(x) To calculate the arccosine of a given number x between -1 and 1. acos(-0.…
-
age
To return the number of full years between now and a given date Use this function to calculate the current number of full years that have passed since a given date.…
-
alert
To open a pop-up with an alert message This function will trigger a pop-up with an alert message and an OK button. You can use this function to display information to the user,…
-
appendTempFile
To add content to a temporary file on the Ninox server This function adds the given content to a temporary file, which will be accessed via a given link created by createTempFile().…
-
appointment
To convert given time-related values to an appointment This function helps you to create a from-to-appointment based on 2 timestamps. Instead of the 2nd timestamp,…
-
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…
-
array
To create a new array by merging 2 arrays of a similar type With this function, you can merge 2 arrays of the same data type and create a new array consisting of the values of both arrays.…
-
asin
To calculate the arcsine The function returns the arcsine of a number. Syntax asin(number) Return number Examples asin(x) To calculate the arcsine of a given number x between -1 and 1. asin(-0.…
-
atan
To calculate the arctangent The function returns the arctangent of a number. Syntax atan(number) Return number Example atan(x) to calculate the arctangent of a given number x between -1 and 1.…
-
atan2
To return the arctangent of the quotient The function returns the arctangent of the quotient of the given parameters. Syntax atan2(number, number) Return number Example atan2(x,…
-
avg
To return the average value of a number array Calculate the mathematical average of numeric values from an array or a table with this function. For example,…
-
barcodeScan
To open the barcode scanner and return the scanned value as a string With this function, you can scan a barcode or QR code via the camera on your mobile device.
To be used only on mobile devices.… -
cached
To run a given script only once and cache and return the output value This function allows you to cache calculations of an elaborate script during the first execution.…
-
capitalize
To capitalize the first letter of each word This function converts the first character of each word in a text into a capital letter. This can be handy to correct entered data that should always begin…
-
ceil
To round up a given number to the nearest integer With this function, you can round up a decimal number to the next higher integer. Existing decimal places are removed,…
-
chosen
To evaluate multiple choice fields The function determines all selected options of a multiple choice field and returns them in an array. You also can query if a specific value is included in the…
-
clientLang
To return the currently used language of the browser or app in abbreviated form This function will help you find out the language a user has set in the respective app.…
-
closeAllRecords
To close all record forms This function will close all currently open forms. You will return to the current view of your table. Use this function for example in a button to speed up the process of…
-
closeFullscreen
To close fullscreen mode This function closes the current fullscreen form view.
This function is best used in a button. Syntax closeFullscreen() Return void Examples Add this function in a formula… -
closeRecord
To close the top record form This function will close the current form. You will then see either the form below or the current view of your table if there was no other form view open.…
-
color
To return or convert to a color value With this function, you can assign a color value to a color or formula field. You also can get the color value of a selected option in a choice field.…
-
concat
To return all items of an array in one string This function returns values from an array, a table, or a multiple-choice field one after the other separated by a comma in a text field or a text…
-
contains
To check if a string or an array contains an exact match This function helps you to check if a given string or array of any length contains the exact match you are looking for.…
-
cos
To calculate the cosine The function returns the cosine of an angle in radians. The result is a numeric value between -1 and 1. Syntax cos(number) Return number Example cos(x) To calculate the cosine…