-
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.…
-
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.… -
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…
-
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,…
-
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.…
-
Revealing some field according to Multiple Choice selections
Hi there, I've created a form with a Multiple Choice field consisting of 5 choices and some hidden fields (check mark). I want these hidden fields to appear whenever the 5th choice is among the other…
-
Register data in a underlaying child-table
I am trying to register the email in a separate underlying table; what am I doing wrong? The table is called 'E-post. sendEmail({ from: userEmail(user()), to: 'E-postadresse', cc: CC.…
-
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.…
-
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,… -
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.…
-
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.…
-
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…
-
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.…
-
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.…
-
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…
-
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.…
-
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.…
-
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…
-
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…
-
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.…
-
popupRecord
To open a given record in a pop-up form This function opens the form of the given record as a pop-up. If you want, you can also specify the tab that should be opened.…
-
phone
To convert a value to a phone value With this function, you can display a formula field as a phone field with a call button. By clicking on the button, you can place a call via your phone client.…
-
parseXML
To convert an XML string to a JSON object This function converts an XML string to a JSON object. The function is of particular interest for connections to external services via API and the processing…
-
parseJSON
To convert a JSON string to a JSON object This function converts a string to a JSON object.
The string needs to be written as a valid JSON object. Otherwise,… -
openURL
To convert a string to a link and open it in the standard web browser With this function, you can open a website in your default browser. You can pass any string,…