-
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,…
-
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 With this function, you can make an API call to access data outside your current database. You can integrate some external services or exchange data between 2 databases.…
-
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…
-
fileMetadata
To return the metadata, like file name, size and modification date of a file based on a given record and file name With this function, you can find out the metadata of a file.…
-
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…
-
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,…
-
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.…
-
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).…
-
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.…
-
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.…
-
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.…
-
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.…
-
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.…
-
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.…
-
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.…
-
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.…