-
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…
-
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.…
-
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.…
-
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…
-
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.…
-
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…
-
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,…
-
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.…
-
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.…
-
day
To return the day of the month from a date value as a number This function extracts the day of a month from a date, appointment, or timestamp; therefore,…
-
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.…
-
datetime
To convert to or return a local timestamp You can use this function to create a timestamp from a date and time or numeric values. If the parameter for the time is missing,…
-
Custom Calendar - Customizable, Offline, Amazing
With the new Custom Calendar Week widget, you can integrate a calendar into any table of your Ninox database and customize it with your data. The design is fully adaptable,…
-
icon
To return an icon With this function, you can assign an icon value to an icon or formula field. You also can get the icon value of a selected option in a choice field.…
-
http
To send an HTTP request With this function, you can make an API call to access data outside your current database. You can integrate some external services or exchange data between 2 databases.…
-
html
To return a rich text representation of any value With this function, you can display text that contains HTML tags. You can use all basic HTML tags for display, but also tables, lists,…
-
formatXML
To convert a given JSON object into XML text, which might be optically structured Use this function to convert data into XML format. XML is beside JSON one of the most popular formats for exchanging…
-
formatJSON
To create a JSON string of a valid JSON object This function converts a JSON object to a string. This can be useful if you want to check the content of an incoming JSON object or if you want to…
-
floor
To round down a given number to the nearest integer With this function, you can round down a decimal number to the next lower integer. Existing decimal places are removed.…
-
first
To return the first item of an array You can access the first entry of an array with this function. This function comes in handy if you try to access a record in an array of records.…
-
files
To return all attachments of a record as an array In contrast to file() with this function, you can address all file attachments of a record, e.g. to send them as an attachment of an automatically…
-
fileMetadata
To return the metadata, like file name, size and modification date of a file based on a given record and file name With this function, you can find out the metadata of a file.…
-
file
To return a specific file based on the file name from a given record With this function, you can address a specific file attachment of a record, e.g. to display it in an image field or to send it as…
-
exp
To calculate the natural exponential function The function calculates the exponential function of a number based on Euler's number and is therefore called the natural exponential function.…