-
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.…
-
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,…
-
atan
To calculate the arctangent The function returns the arctangent of a number. Syntax atan(number) Return number Example 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.…
-
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 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…