-
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.…
-
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…
-
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.…
-
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).…
-
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.…
-
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.…
-
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.…
-
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:…
-
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,… -
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,…
-
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…
-
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.…
-
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.… -
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,… -
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 ("").…
-
cos
To calculate the cosine The function returns the cosine of an angle in radians. The result is a numeric value between -1 and 1. Syntax cos(number) Return number Example cos(x) To calculate the cosine…
-
contains
To check if a string or an array contains an exact match This function helps you to check if a given string or array of any length contains the exact match you are looking for.…
-
concat
To return all items of an array in one string This function returns values from an array, a table, or a multiple-choice field one after the other separated by a comma in a text field or a text…
-
color
To return or convert to a color value With this function, you can assign a color value to a color or formula field. You also can get the color value of a selected option in a choice field.…
-
closeFullscreen
To close fullscreen mode This function closes the current fullscreen form view.
This function is best used in a button. Syntax closeFullscreen() Return void Examples Add this function in a formula… -
closeRecord
To close the top record form This function will close the current form. You will then see either the form below or the current view of your table if there was no other form view open.…
-
closeAllRecords
To close all record forms This function will close all currently open forms. You will return to the current view of your table. Use this function for example in a button to speed up the process of…
-
clientLang
To return the currently used language of the browser or app in abbreviated form This function will help you find out the language a user has set in the respective app.…
-
chosen
To evaluate multiple choice fields The function determines all selected options of a multiple choice field and returns them in an array. You also can query if a specific value is included in the…
-
atan2
To return the arctangent of the quotient The function returns the arctangent of the quotient of the given parameters. Syntax atan2(number, number) Return number Example atan2(x,…
Functions are the practical application of the Ninox scripting language to process data and navigate the solution