-
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.…
-
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.…
-
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…
-
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.…
-
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.…
-
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.…
-
Lost colours and icon?
Anyone lost the colours across the top along with replacement of the Ninox icon top left? I cannot replace the icon or colours - still on most recent update ending in .6 (cloud)
- Answered
-
Older release notes
The features apply to all platforms; exceptions are indicated. Ninox 3.4 – July 5, 2021 For a detailed description of the changes, check our release blog.… -
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 ("").…
-
Sort and display all times in order.
Hello everyone! In my table, I’ve set up two time fields (as shown in the image). I’m wondering if I can create a code snippet in the ‘View’ table to display all the entries of time1 and time2 in…
- Answered
-
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.…