unshareAllViews

To unshare all views of a given table This function will stop sharing all views of a table. This function doesn't work in a formula field because it's modifying data.…

unique

To return an array with unique elements Filter out duplicates from one or more arrays to get an array with only unique values. This can be helpful to make sure there are no double entries in your…

trim

To remove preceding and following spaces Especially when copying & pasting text from another source, it can happen, that you also “import” spaces that are unwanted.…

today

To return the current date (without time) Here you can determine the current date, i.e. the respective day on which the function is executed. Therefore,…

timestamp

To convert a given time-related value to a timestamp With this function, you will convert a time-related value to a UTC-based timestamp. If you use a value without time,…

timeinterval

To convert a given time-related value to a time interval, i.e. a duration To convert a given time-related value to a time interval, i.e. a duration. If the value is a number,…

time

To return the current time With this function, you can return the current time or set a time. You can use this function for calculations with other time-related data types.…

text

To convert a value to a string and possibly reflect the format options With this function, you can convert almost any data type at Ninox to a text value.…

testx

To check if a text has matches with a given regular expression This function does the same as contains(): it checks a text for the occurrence of a certain string.…

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…