-
log
To calculate the logarithm The function returns the logarithm of a number to a base. If no parameter is specified for the base, it is 10. In the case of 0, the result is -∞ (minus infinity).…
-
longitude
To return the longitude of a given location value This function will extract the longitude of an address in a location field as a decimal number. Syntax longitude(location) Return number Examples…
-
lower
To output a string in lowercase This function converts uppercase characters in a text to lowercase. Other characters stay untouched. This can be useful for comparing strings or for correcting…
-
lpad
To fill up a given length with given padding at the beginning With this function, you fill a text at the beginning, i.e. to the left of the text, with one or more given characters up to the desired…
-
max
To return the highest or latest value of an array Use this function to find the highest value or the latest value in an array.
The function works only with an array of numbers or time-related… -
min
To return the lowest or earliest value of an array Use this function to find the lowest value or the earliest value in an array.
The function works only with an array of numbers or time-related… -
month
To return the month from a date value as a number Use this function to return the month from a date value. This will be a number between 1 and 12, with January = 1, February = 2, … December = 12.…
-
monthIndex
To return a given month as a number out of a string With this function you extract the number of the month from a string, for example, March will be 3. This is helpful if the month is only available…
-
monthName
To return the full month name of a given date value This function will display the month’s name. This might be helpful if you want to group dates within a year by month.…
-
ninoxApp
To identify the type of environment that is currently being used This function lets you know in which environment Ninox is currently executed. Your return values could be web (on Ninox cloud) mac (on…
-
now
To return the current timestamp This function gives you the exact date and time from the exact moment when the function is executed. You are creating an exact timestamp.…
-
number
To convert a given value to a number It returns the values of different data types as a number. You can imagine this is needed quite often. The result depends on the data type.…
-
numbers
To return the IDs of the selected choice values of a given multiple choice field With this function, you'll get the IDs of the selected options. Multiple choice field:…
-
odd
To return Yes (true) if the number is odd With this function, you can check whether a number is odd, i.e. not divisible by 2 without remainder. The return value is either Yes (true) or No (false).…
-
openFullscreen
To open a given record in fullscreen mode This function will open the form view to fullscreen. Specify the record, which you'd like to show in fullscreen mode.…
-
openPage
To open a given page This function closes the current page and opens the given page. You can specify the request by adding a tab you want the page to be opened with.…
-
openPrintLayout
To open a record in a given layout in the print layout editor This function will open a specific print layout of a given record. Syntax openPrintLayout(nid,…
-
openRecord
To jump to the related table and open a given record This function closes your current form and opens the form of the given record together with the respective table.…
-
openTable
To open a given table This function closes the current table and opens a given table. You can specify the request by adding a view you want the table to be opened with.…
-
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,…
-
parseCSV
To return a structured list or array of rows and data from specified CSV text The parseCSV function parses CSV-formatted text into a structured list or array.…
-
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,… -
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…
-
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.…
-
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.…