Search
⌃K
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

​appendTempFile​

To create a temporary file on the Ninox server

​appointment​

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

​barcodeScan​

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

​capitalize​

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

​clientLang​

To return the currently used language of the browser or app in abbreviated form

​closeAllRecords​

To close all record forms

​closeFullscreen​

To close full-screen mode

​closeRecord​

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

​createTempFile​

To add content to a temporary file on the Ninox server

​createTextFile​

To create a text file with a given name and content

​createZipFile​

To create a zip archive including all files of a given file array

​databaseId​

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

​fileMetadata​

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

​formatJSON​

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

​importFile​

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

​invalidate​

To clear the cache of the database and the values stored by cached()

​isAdminMode​

To return Yes (true) if the edit mode is on

​isDatabaseLocked​

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

​loadFileAsBase64​

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

​monthIndex​

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

​openFullscreen​

To open a given record in full-screen mode

​openPrintLayout​

To open a record in a given layout in the print layout editor

​openRecord​

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

​popupRecord​

To open a given record in a pop-up form

​pow​

To calculate the power of a number

​printAndSaveRecord​

To save a given record in a given layout as a PDF in the internal file system and return a link to the file

​printRecord​

To print to a PDF from a given record in a given layout and open the file with a program set as default

​printTable​

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

​queryConnection​

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

​removeItem​

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

​sendCommand​

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

​timeinterval​

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

​unshareAllViews​

To unshare all views of a given table

​unshareFile​

To unshare a given file

​unshareView​

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

​userFirstName​

To return the first name of a user

​userFullName​

To return the full name of a user

​userHasRole​

To return Yes (true) if a user has a given role

​userId​

To return the ID of a user

​userIsAdmin​

To return Yes (true) if the current user has the admin role

​userLastName​

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

​waitForSync​

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

​weekdayIndex​

To return a given weekday name as a number

​weekdayName​

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

​yearquarter​

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