Links

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 between now and a given date (e.g. a person’s age)

alert

To open a pop-up with an alert message
To create a temporary file on the Ninox server
To convert given time-related values to an appointment

array

To create a new array by merging 2 arrays of a similar type

asin

To calculate the arcsine

atan

To calculate the arctangent

atan2

To calculate the arctangent of the quotient of x/y

avg

To return the average of a number array
To open the barcode scanner and return the scanned value as a string

cached

To run a given script only once and cache and return the output value
To capitalize the first letter of each word

ceil

To round up a given number to the nearest integer

chosen

To evaluate multiple-choice fields
To return the currently used language of the browser or app in abbreviated form
To close all record forms
To close full-screen mode
To close the top record form

color

To return or convert to a color value

concat

To return all items of an array in one string

contains

To check if a string or an array contains an exact match

cos

To calculate the cosine

count (aka cnt)

To return the number of concrete items in an array
To create an event in the Apple Calendar App
To create a reminder in the Apple Reminder App
To add content to a temporary file on the Ninox server
To create a text file with a given name and content
To create a zip archive including all files of a given file array
To return the ID of the current database

date

To convert to or return a date value

datetime

To convert to or return a timestamp

day

To return the day of the month from a given date value as a number

days

To return the number of days between 2 dates

degrees

To convert an angle from radians to degrees

dialog

To pop up a dialog with answer options

duplicate

To create a duplicate of a given record

duration

To return the duration of an appointment

email

To convert a given value to an email value

endof

To return the end of an appointment.

even

To return Yes (true) if the number is even

exp

To calculate the natural exponential function

extractx

To extract a substring from a given string using a regular expression

file

To return a specific file based on the file name from a given record
To return the metadata, like file name, size and modification date of a file based on a given record and file name

files

To return all attachments of a record as an array

first

To return the first item of an array

floor

To round down a given number to the nearest integer

format

To format a given value
To create a JSON string of a valid JSON object

formatXML

To convert a given JSON object into XML text, which might be optically structured

html

To return a rich text representation of any value

http

To send an HTTP request

icon

To return an icon
To import a file from a URL and save it as an attachment of a record

index

To return the start position of the first match in a string or an array
To clear the cache of the database and the values stored by cached()
To return Yes (true) if the edit mode is on
To return Yes (true) if the database is locked
To return Yes (true) if a password is needed to activate the edit mode

item

To extract a value of an array or an object

join

To return a string consisting of all items of the given string array separated by a given separator

last

To return the last item of an array

latitude

To return the latitude value of a given location value

length

To return the count of all characters in a string or all items in an array.

ln

To calculate the natural logarithm
To convert a file to base64 format
To convert a file to URL-compliant base64 format

location

To return a location value with a given title, latitude, and longitude

log

To calculate the logarithm

longitude

To return the longitude of a given location value

lower

To return a string in lower case

lpad

To fill up a given length with given padding at the beginning

max

To return the highest or latest value of an array

min

To return the lowest or earliest value of an array

month

To return the month from a given date value as a number
To return a given month as a number out of a string

monthName

To return the full month name of a given date value

ninoxApp

To identify the type of environment that is currently being used

now

To return the current timestamp

number

To convert a given value to a number

numbers

To return the IDs of the selected choice values of a given multiple choice field

odd

To return Yes (true) if the number is odd
To open a given record in full-screen mode
To open a record in a given layout in the print layout editor
To jump to the related table and open a given record

openTable

To open a given table

openURL

To convert a string to a link and open it in the standard web browser

parseJSON

To convert a JSON string to a JSON object

parseXML

To convert an XML string to a JSON object

phone

To convert a value to a phone value
To open a given record in a pop-up form

pow

To calculate the power of a number
To save a given record in a given layout as a PDF in the internal file system and return a link to the file
To print to a PDF from a given record in a given layout and open the file with a program set as default
To print the visible columns of a given view according to your database settings (PDF or HTML)

quarter

To return the quarter of a given date value as a number
To send a SQL command to a connected SQL database and return the record data.

radians

To convert an angle from degrees to radians

random

To return a random number

range

To return an array of consecutive numbers

raw

To return the internal raw text representation of a given value

record

To return a record of a table by a given ID
To remove a key-value pair from a given JSON object

replace

To replace a pattern in a string with a given replace

replacex

To replace the matches of a given regular expression with a given string in a given text.

round

To round a given number

rpad

To fill up a given length with a given padding at the end

rsort

To sort an array in descending order
To send a SQL command to a connected SQL database

sendEmail

To send an email out of Ninox

setItem

To update or add a key-value pair in a given JSON object

shareFile

To return an URL of a specific file

shareView

To return a URL of a given view

sign

To return the signum of a number

sin

To calculate the sine

sleep

To force Ninox to wait for a given number of milliseconds before continue running the code

slice

To extract a subrange from a string or array

sort

To sort values in ascending order

split

To split a string into an array at each separator

splitx

To split a string into an array by using a regular expression

sqr

To calculate the square

sqrt

To calculate the square root

start

To return the start timestamp of an appointment

string

To convert a given value to a string

styled

To convert a given string to a styled object

substr

To return a substring out of a given text

substring

To return a substring out of a given text with a given start and a given end

sum

To return the total sum of a number array

tableId

To return the ID of a table

tan

To calculate the tangent

teamId

To return the ID of the current workspace

testx

To check if a text has matches with a given regular expression

text

To convert a value to a string and possibly reflect the format options

time

To return the current time
To convert a given time-related value to a time interval, i.e. a duration

timestamp

To convert a given time-related value to a timestamp

today

To return the current date (without time).

trim

To remove preceding and following spaces

unique

To return an array with unique elements
To unshare all views of a given table
To unshare a given file
To unshare a given view of a given table

upper

To return a string in the upper case

url

To convert a value to a link

urlDecode

To decode a given string from a URL-compliant format into text

urlEncode

To convert a given string into a URL-compliant string based on the ASCII character set

urlOf

To return a link for a given record or view

user

To return the current or a specific user

userEmail

To return the email address of a user
To return the first name of a user
To return the full name of a user
To return Yes (true) if a user has a given role

userId

To return the ID of a user
To return Yes (true) if the current user has the admin role
To return the last name of a user

userName

To return the username of a user

userRole

To return the role of the current or a given user

userRoles

To return all roles of a user

users

To return the IDs of all collaborators in an array
To return Yes (true) if the database is synced with the Ninox cloud

week

To return the calendar week of a given date value

weekday

To return the weekday of a given date value as a number
To return a given weekday name as a number
To return the full weekday name of a given date value

workdays

To return the number of working days between 2 given dates

year

To return the year of a given date value

yearmonth

To return the month and the year of a given date value
To return the quarter and the year of a given date value

yearweek

To return the week and the year of a given date value