-
pow
To calculate the power of a number The function returns the power of a base number using the exponent. If the exponent has the value 0.5, the result is the root of the base number.…
-
printAndSaveRecord
To generate a PDF from a record or Carbone template, save it in Ninox's internal file system, and return a download link This function creates a PDF from a specified record in either a Ninox layout…
-
printRecord
To print to a PDF from a given record in a given layout and open the file with a program set as default This function prints a record in a PDF and automatically downloads the PDF to your computer on…
-
printTable
To print the visible columns of a given view according to your database settings (PDF or HTML) With this function, you can print a table view in a default layout to a PDF or HTML.…
-
quarter
To calculate the power of a number The function returns the power of a base number using the exponent. If the exponent has the value 0.5, the result is the root of the base number.…
-
queryConnection
To send an SQL command to a connected SQL database and returns the record data In case you want to send a command to a connected SQL database, use this function to send your command as a string…
-
radians
To convert an angle from degrees to radians The function returns the corresponding radian of a degree value. It is mostly used for trigonometric calculations.…
-
random
To return a random number The function generates a random number between 0 (inclusive) and 1 (exclusive). Therefore the return value is equal to or greater than 0 and less than 1.…
-
range
To return an array of consecutive numbers With this function, you can define a numeric value range with a from-to specification. Where from might be set automatically to 0 if there is only one…
-
raw
To return the internal raw text representation of a given value You can use this function to convert a value to the system's internal text representation.…
-
record
To return a record of a table by a given ID With this function, you can return a specific record by the table name and the unique record ID. If this record doesn't exist, null will be returned.…
-
removeFile
To securely remove a file from a field or record This function removes a file by specifying either: A file object that contains the necessary information (nid and the file name).…
-
removeItem
To remove a key-value pair from a given JSON object This function allows you to remove key-value pairs from an already existing JSON object.
If your JSON object is stored in a variable,… -
renameFile
To rename a file in a field or record This function renames a file by specifying either: A file object that contains the necessary information (nid and the file name).…
-
replace
To replace a pattern in a string with a given replace This function allows you a simple search & replace as you know it from a word processing program: You search in a text for a certain string.…
-
replacex
To replace the matches of a given regular expression with a given string in a given text This function extends the replace() function and gives you the possibility to search using regular expressions.…
-
round
To round a given number You can use the function to round a decimal number to the specified number of decimal places. This is done according to the rules of commercial rounding,…
-
rpad
To fill up a given length with a given padding at the end With this function, you fill a text at the end, i.e. to the right of the text, with one or more specified characters up to the desired total…
-
rsort
To sort an array in descending order This function helps you to sort values in descending order.
You can pass any number of parameters. Requirement: They have the same data type.… -
sendCommand
To send a SQL command to a connected SQL database In case you want to send a command to a connected SQL database, use this function to send your command as a string through a specified connection.…
-
sendEmail
To send an email out of Ninox With this function, you can send emails right out of Ninox. You can enter email details directly to the function or pull them from the respective fields.…
-
set
To update a value of a given field This function updates a field and its value. You can use set to modify a field by specifying its name or ID as text, such as "Name" or "A.…
-
setItem
To update or add a key-value pair in a given JSON object With this function, you can update an already existing JSON object and add more data to it.
If your JSON object is stored in a variable,… -
shareFile
To return a URL of a specific file Use this function to create a link to share an image or an attachment per script.
The shareFile function generates a share link that is only valid within the… -
shareView
To return a URL of a given view With this function, you can share a table view per script. If you don't specify the view to be shared, the default view will be selected.…