Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
An overview of the array functions
To create a new array by merging 2 arrays of a similar type
To return the average of a number array
To return Yes (true
) if the given value equals a given selection
To return all items of an array in one string
To check if a string or an array contains an exact match
To return the number of concrete items in an array
To return all attachments of a record as an array
To return the first item of an array
To return the start position of the first match in a string or an array
To extract a value of an array or an object
To return a string consisting of all items of the given string array separated by a given separator
To return the last item of an array
To return the count of all characters in a string or all items in an array
To return the highest or latest value of an array
To return the lowest or earliest value of an array
To return the IDs of the selected choice values of a given multiple choice field
To return an array of consecutive numbers
To sort an array in descending order
To extract a subrange from a string or array
To sort values in ascending order
To split a string into an array at each separator
To split a string into an array by using a regular expression
To return the total sum of a number array
To return an array with unique elements
To run a given script only once and cache and return the output value
To close all record forms
To close full-screen mode
To close the top record form
To return the ID of the current database
To create a duplicate of a given record
To clear the cache of the database and the values stored by cached()
To open a given record in full-screen mode
To open a given page
To jump to the related table and open a given record
To open a given table
To save a given record in a given layout as a PDF in the internal file system and return a link to the file
To return a record of a table by a given ID
To force Ninox to wait for a given number of milliseconds before continue running the code
To return an array with unique elements
To return Yes (true
) if the database is synced with the Ninox cloud
An overview of date- and time-related functions
To return the number of full years between now and a given date (e.g. a person’s age)
To convert given time-related values to an appointment
To create an event in the Apple Calendar App
To create a reminder in the Apple Calendar App
To convert to or return a date value
To convert to or return a timestamp
To return the day of the month from a given date value as a number
To return the number of days between 2 dates
To return the duration of an appointment
To return the end of an appointment.
To format a given value
To return the month from a date value as a number
To return a given month as a number out of a string
To return the full month name of a given date value
To return the current timestamp
To return the quarter of a given date value as a number
To return the start timestamp of an appointment
To return the current time
To convert a given time-related value to a time interval, i.e. a duration
To convert a given time-related value to a timestamp
To return the current date (without time).
To return the calendar week of a given date value
To return the weekday of a given date value as a number
To return a given weekday name as a number
To return the full weekday name of a given date value
To return the number of working days between 2 given dates
To return the year of a given date value.
To return the month and the year of a given date value
To return the quarter and the year of a given date value
To return the week and the year of a given date value
An overview of functions, that help you to format and convert data types
To convert given time-related values to an appointment
To create a new array by merging 2 arrays of a similar type
To dynamically create customizable, styled, multi-sheet Excel files directly from databases
To convert to or return a date value
To convert to or return a timestamp
To convert a given value to an email value
To format a given value
To create a JSON string of a valid JSON object
To convert a given JSON object into XML text, which might be optically structured
To return a rich text representation of any value
To convert a file to base64 format
To convert a file to URL-compliant base64 format
To return a string in lower case
To return a given month as a number out of a string
To return the full month name of a given date value
To convert a given value to a number
To convert a JSON string to a JSON object
To convert an XML string to a JSON object
To convert a number or string to a phone value
To remove a key-value pair from a given JSON object
To update or add a key-value pair in a given JSON object
To convert a given value to a string
To convert a given string to a styled object
To convert a value to a string and possibly reflect the format options
To convert a given time-related value to a time interval, i.e. a duration
To convert a given time-related value to a timestamp
To return a string in the upper case
To convert a string to a link
An overview of functions to help you to manage files and printing
To create a temporary file on the Ninox server
To add content to a temporary file on the Ninox server
To create a text file with a given name and content
To dynamically create customizable, styled, multi-sheet Excel files directly from databases
To create a zip archive including all files of a given file array
To return a specific file based on the file name from a given record
To return the metadata, like file name, size, and modification date of a file based on a given record and file name
To return all attachments of a record as an array
To import a file from a URL and save it as an attachment of a record
To convert a file to base64 format
To convert a file to URL-compliant base64 format
To open a record in a given layout in the print layout editor
To save a given record in a given layout as a PDF in the internal file system and return a link to the file
To print to a PDF from a given record in a given layout and open the file with a program set as default
To print the visible columns of a given view according to your database settings (PDF or HTML)
To return an URL of a specific file
To unshare a given file
To unshare a given view of a given table
An overview of the functions related to your user interface
To open a pop-up with an alert message
To open the barcode scanner and return the scanned value as a string
To close all record forms
To close fullscreen mode
To close the top record form
To return or convert to a color value
To pop up a dialog with answer options
To return an icon
To identify the type of environment that is currently being used
To open a given record in fullscreen mode
To open a given page
To open a record in a given layout in the print layout editor
To jump to the related table and open a given record
To open a given table
To open a given record in a pop-up form
To convert a given string to a styled object
An overview of text-related functions
To capitalize the first letter of each word
To return Yes (true
) if the given value equals a given selection
To return all items of an array in one string
To check if a given string contains the exact given match
To create a text file with a given name and content
To extract a substring from a given string using a regular expression
To format a given value
To return a rich text representation of any value
To return the first position of appearance of a match in a string starting
To return a string consisting of all items of a given string array separated by a given separator
To return the count of all characters in a string or all items in an array
To output a string in lower case
To fill the missing space with a given padding at the beginning
To return the internal raw text representation of a given value
To replace a pattern in a string with a given replace.
To replace any "find" with "replace" in a "text"
To fill the missing space of the given padding at the end, if the length of a given string is shorter than a given length
To extract a sub-array
To split a string into an array at each separator
To convert a given value to a string
To return a styled text element
To return a new string out of a given text
To return a new string out of a given text with a given start and a given end
To return Yes (true
) if a given text matches a given regular expression.
To convert a value to a string that possibly reflects the format options
To remove preceding and following spaces
To output a string in the upper case
An overview of mathematical functions to perform tasks on numbers
To return the absolute value of a number
To calculate the arccosine
To calculate the arcsine
To calculate the arctangent
To calculate the arctangent of the quotient of x/y
To return the average of a number array
To round up a given number to the nearest integer
To calculate the cosine
To convert an angle from radians to degrees
To return Yes (true
) if the number is even
To calculate the natural exponential function
To round down a given number to the nearest integer
To format a given value
To calculate the natural logarithm
To calculate the logarithm
To return the highest or latest value of an array
To return the lowest or earliest value of an array
To return Yes (true
) if the number is odd
To calculate the power of a number
To convert an angle from degrees to radians
To return a random number
To round a given number
To return the signum of a number
To calculate the sine
To calculate the square
To calculate the square root
To return the total sum of a number array
To calculate the tangent
An overview of all user management related functions
To return the currently used language of the browser or app in abbreviated form
To return Yes (true
) if the edit mode is on
To return Yes (true
) if the database is locked
To return Yes (true
) if a password is needed to activate the edit mode
To return the type of platform that is currently being used
To return the current or a specific user
To return the email address of a user
To return the first name of a user
To return the full name of a user
To return Yes (true
) if a user has a given role
To return the ID of a user
To return Yes (true
) if the current user has the admin role
To return the last name of a user
To return the username of a user
To return the role of a user
To return all roles of a user
To return the IDs of all current users in an array
An overview of functions to connect your databases to external services and think outside the box
To create an event in the Apple Calendar App
To create a reminder in the Apple Calendar App
To return the ID of the current database
To create a JSON string of a valid JSON object
To convert a given JSON object into XML text, which might be optically structured
To return a rich text representation of any value
To send an HTTP request
To extract a value of an array or an object
To return the latitude value of a given location value
To convert a file to base64 format
To convert a file to URL-compliant base64 format
To return a location value with a given title, latitude, and longitude
To return the longitude of a given location value
To convert a string to a link and open it in the standard web browser
To convert a JSON string to a JSON object
To convert an XML string to a JSON object
To send a SQL command to a connected SQL database and return the record data.
To return the internal raw text representation of a given value
To remove a key-value pair from a given JSON object
To send a SQL command to a connected SQL database
To send an email out of Ninox
To update or add a key-value pair in a given JSON object
To return an URL of a specific file
To return a URL of a given view
To return the ID of a table
To return the ID of the current workspace
To unshare all views of a given table
To unshare a given file
To unshare a given view of a given table
To convert a value to a link
To decode a given string from a URL-compliant format into text
To convert a given string into a URL-compliant string based on the ASCII character set
To return a link for a given record or view