-
count (aka cnt)
To return the number of concrete items in an array With this function, you can count the number of entries in arrays or tables that are not null or empty strings ("").…
-
Sort and display all times in order.
Hello everyone! In my table, I’ve set up two time fields (as shown in the image). I’m wondering if I can create a code snippet in the ‘View’ table to display all the entries of time1 and time2 in…
- Answered
-
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…
-
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.…
-
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.…
-
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 What it does http() lets your script call any REST API—to pull data from another service or push data between Ninox databases. ℹ️ Accessing a different Ninox database requires…
-
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…