-
fileUrl
To return the URL of a specific file from a record This function allows you to directly link to a specific file (e.g. an image or attachment) stored in a record—perfect for use in PDFs, emails,…
-
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.…
-
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.…
-
format
With the function, you can format numbers, date, and time values as you need them, to use them in text or formula fields.
Note: All entries are optional.… -
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…
-
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…
-
get
To return a value of a given field This function retrieves the value of a field. You can use get to access fields by their name or ID, making it easy to extract data for use in scripts and…
-
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,…
-
http
To send an HTTP request What it does http() lets your script call any REST API—to pull data from another service or push data between Ninox databases.
Accessing a different Ninox database requires… -
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.…
-
importFile
To import a file from a URL and save it as an attachment of a record With this function, you can import a file and attach it to a record or insert it in an image field.…
-
index
To return the start position of the first match in a string or an array With this function, you can determine the position of a searched value within a given string or an array.…
-
invalidate
To clear the cache of the database and the values stored by cached() If you execute this function in any table of your database, all values in the database cache (e.g. via cached()) will be deleted.…
-
isAdminMode
To return Yes (true) if the edit mode is active With this function, you'll find out if the current user is in edit mode, i.e. the wrench icon is activated (red).…
-
isDatabaseLocked
To return Yes (true) if the database is locked This function helps you find if the edit mode needs a password to be enabled and if it is already entered... or not.…
-
isDatabaseProtected
To return Yes (true) if a password is needed to enable edit mode Check if enabling edit mode in a database requires a password. Syntax isDatabaseProtected() Return boolean Examples…
-
item
To extract a value of an array or an object With this function, you can access a specific element in an array or JSON object based on a given index or key.…
-
join
To return a string consisting of all items of the given string array separated by a given separator. Merge multiple elements from an array or table into one string.…
-
last
To return the last item of an array You can access the last entry of an array with this function. This function comes in handy if you try to access a record in an array of records.…
-
latitude
To return the latitude value of a given location value This function will extract the latitude of an address in a location field as a decimal number. Syntax latitude(location) Return number Example…
-
length
To return the count of all characters in a string or all items in an array This function returns the number of characters (with spaces) of a given text or the number of items in a given array.…
-
ln
To calculate the natural logarithm The function returns the logarithm to base e (the Euler’s number) and is therefore called the natural logarithm. It returns a positive number.…
-
loadFileAsBase64
To converts a file to base64 format This function converts a file into a base64 string. You can then use this in a REST API call, for example. Syntax loadFileAsBase64(file) loadFileAsBase64(nid,…
-
loadFileAsBase64URL
To convert a file to URL-compliant base64 format This function converts a file into a URL-compliant base64 string. You can then use this in a REST API call, for example.…
-
location
To return a location value with a given title, latitude, and longitude This function returns a location value based on a given latitude and longitude, which can have a random title.…