0

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

 

createCalendarEvent

To create an event in the Apple Calendar App

 

createCalendarReminder

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

 

createXLSX

To dynamically create customizable, styled, multi-sheet Excel files directly from databases

 

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

 

fieldId

To return the ID of a field

 

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

 

get

To return a value of a given field

 

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

 

isDatabaseProtected

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

 

loadFileAsBase64URL

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

 

removeFile

To securely remove a file from a field or record

 

removeItem

To remove a key-value pair from a given JSON object

 

renameFile

To rename a file in a field or record

 

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

 

set

To update a value of a given field

 

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

Reply

null