-
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 Examples databaseId()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 Examples cos(x) To calculate the…
-
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 Examples atan2(x,…
-
atan
To calculate the arctangent The function returns the arctangent of a number. Syntax atan(number) Return number Examples atan(x) To calculate the arctangent of a given number x between -1 and 1.…
-
asin
To calculate the arcsine The function returns the arcsine of a number. Syntax asin(number) Return number Examples asin(x) To calculate the arcsine of a given number x between -1 and 1. asin(-0.…