-
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.…
-
sign
To return the signum of a number You can use the function to determine the sign of a number. The return value is either 1 (positive number) or -1 (negative number).…
-
sin
To calculate the sine The function can be used to determine the sine of a number. The result is a numeric value between -1 and 1. Syntax sin(number) Return number Examples sin(x) To calculate the…
-
sleep
To force Ninox to wait for a given number of milliseconds before continue running the code With this function, you can put Ninox on hold before continuing to execute your script.…
-
slice
To extract a subrange from a string or array This function helps you to extract a partial range of an array and transfer it to a new array. You define the part you want to extract by a start and an…
-
sort
To sort values in ascending order This function helps you to sort values in ascending order.
You can pass any number of parameters. Requirement: They have the same data type.… -
split
To split a string into an array at each separator This function will split a string into single components. These components are assembled into an array.…
-
splitx
To split a string into an array by using a regular expression This function will split a string into single components using a regular expression. These components are assembled into an array.…
-
sqr
To calculate the square The function squares a number, i.e. multiplies it by itself. The result is always positive. Syntax sqr(number) Return number Examples sqr(x) To calculate the square of a…
-
sqrt
To calculate the square root Use the function to find the square root of a positive number.
If the number has a negative sign, use the function abs() for example to convert it to a positive number… -
start
To return the start timestamp of a given appointment With this function, you can address the start of an appointment. The function will return the date + time of the appointment,…
-
string
To convert a given value to a string This function will return the data of a field or an array as text. It’s a bit like the function concat(). If you use this function on a multiple-choice field,…
-
styled
To convert a given string to a styled object With this function, you can style a formula field with colors (for example the background) but also with an additional icon.…
-
substr
To return a new string out of a given text This function extracts a part of a text according to your specifications. You need to provide the start position,…
-
substring
To return a new string out of a given text with a given start and a given end This function extracts a part of a text according to your specifications. You need to provide the start position,…
-
sum
To return the total sum of a number array With the function, you can calculate the mathematical sum of numeric values from an array or a table. For example,…
-
tableId
To return the ID of a table With this function, you'll find out the internal identifier of the current table. This ID consists of at least 1 capital letter. It starts with A.…
-
tan
To calculate the tangent The function returns the tangent of an angle. Syntax tan(number) Return number Examples tan(x) To calculate the tangent of a number x. tan(1) Result: 1.5574077246549023 tan(1.…