-
date
To convert to or return a date value This function extracts the date from a timestamp. It also returns a date based on the numeric values for year, month, and day.…
-
appointment
To convert given time-related values to an appointment This function helps you to create a from-to-appointment based on 2 timestamps. Instead of the 2nd timestamp,…
-
ceil
To round up a given number to the nearest integer With this function, you can round up a decimal number to the next higher integer. Existing decimal places are removed,…
-
capitalize
To capitalize the first letter of each word This function converts the first character of each word in a text into a capital letter. This can be handy to correct entered data that should always begin…
-
cached
To run a given script only once and cache and return the output value This function allows you to cache calculations of an elaborate script during the first execution.…
-
barcodeScan
To open the barcode scanner and return the scanned value as a string With this function, you can scan a barcode or QR code via the camera on your mobile device.
To be used only on mobile devices.… -
avg
To return the average value of a number array Calculate the mathematical average of numeric values from an array or a table with this function. For example,…
-
appendTempFile
To add content to a temporary file on the Ninox server This function adds the given content to a temporary file, which will be accessed via a given link created by createTempFile().…
-
alert
To open a pop-up with an alert message This function will trigger a pop-up with an alert message and an OK button. You can use this function to display information to the user,…
-
age
To return the number of full years between now and a given date Use this function to calculate the current number of full years that have passed since a given date.…
-
acos
To calculate the arccosine The function returns the arccosine of a number. Syntax acos(number) Return number Example acos(x) To calculate the arccosine of a given number x between -1 and 1. acos(-0.…
-
abs
To return the absolute value of a number The function removes existing signs and returns the absolute, positive value of a number. It happens rather rarely, but for certain calculations,…
-
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.…
-
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.…
-
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,…
-
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.…
-
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.…
-
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).…
-
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:…