-
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 ("").…
-
createCalendarEvent
To create an event in the Apple Calendar app
Available on our apps for Mac, iPad, and iPhone. Not on web browsers or Android apps. With this function,… -
createCalendarReminder
To create a reminder in the Apple Calendar app
Available on our apps for Mac, iPad, and iPhone. Not on web browsers or Android apps. Create a reminder in the Apple Reminder app with this function.… -
createTempFile
To create a temporary file on the Ninox server This function creates a temporary file on the Ninox server with the given content and file name and returns a link to that file.…
-
createTextFile
To create a text file with a given name and content With this function, you can create a simple text file (.txt). If not otherwise specified, the file is simply attached to the record (look for the…
-
createXLSX
To dynamically create customizable, styled, multi-sheet Excel files directly from databases With this function, you can create an XLSX file with customizable content and multiple sheets,…
-
createZipFile
To create a zip archive including all files of a given file array With this function, you create a zip archive containing all files passed in an array.
At the moment,… -
Database operations
cached To run a given script only once and cache and return the output value closeAllRecords To close all record forms closeFullscreen To close full-screen mode closeRecord To close the top record…
-
databaseId
To return the ID of the current database This function tells you the ID of the current database you are in. Syntax databaseId() Return string Example databaseId() Result:…
-
date
To convert to or return a date value This function extracts the date from a timestamp. It also returns a date based on the numeric values for year, month, and day.…
-
Date and time
An overview of date- and time-related functions age To return the number of full years between now and a given date (e.g. a person’s age) appointment To convert given time-related values to an…
-
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,…
-
day
To return the day of the month from a date value as a number This function extracts the day of a month from a date, appointment, or timestamp; therefore,…
-
days
To return the number of days between 2 dates With this function, you calculate the number of days between 2 date values. All days of the week count, i.e. Monday until Sunday.…
-
degrees
To convert an angle from radians to degrees The function returns the corresponding degree value of a radian. It is mostly used for trigonometric calculations.…
-
dialog
To pop up a dialog with answer options This function will trigger a pop-up with notes created by you. You can add a selection of options with answers to choose from, for example, Yes or No.…
-
duplicate
To create a duplicate of a given record With this function, you create an exact duplicate of the record to which you apply this function. Also, linked data from sub-tables will be transferred.…
-
duration
To return the duration of an appointment This function calculates the duration of an appointment for you, i.e. the time between the start and the end. The result is shown in hours and minutes.…
-
email
To convert a given value to an email value This function converts a regular formula field to an email field with a mailto button. Click the button to open your local email clients and send an email.…
-
endof
To return the end timestamp of a given appointment The function returns the end timestamp of a given appointment. The result is a value with date and time, which can be further processed or formatted.…
-
even
To return Yes (true) if the number is even With this function, you can check whether a number is even, i.e. divisible by 2 without remainder. The return value is either Yes (true) or No (false).…
-
exp
To calculate the natural exponential function The function calculates the exponential function of a number based on Euler's number and is therefore called the natural exponential function.…
-
extractx
To extract a string from a given text using a regular expression With this function, you can extract the first match of a search string in a text. Instead of simple strings as a search pattern,…
-
fieldId
To return the ID of a field This function retrieves the internal identifier of a specified field. A field represents a location stored within a row of a table in a database.…
-
file
To return a specific file based on the file name from a given record With this function, you can address a specific file attachment of a record, e.g. to display it in an image field or to send it as…