-
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,…
-
Sample configuration file
💡 Content in curly brackets { } signifies a placeholder. Both the curly brackets and the content within must be replaced for the request to work. server-config.…
-
Learn More About the Upcoming Ninox Version 3.14 this Thursday!
Let’s Explore the New Ninox Version 3.14 with an Open Q&A Thursday, 7 November at 12pm EST/ 5pm GMT/ 6pm CET FREE REGISTRATION: https://us02web.zoom.us/webinar/register/WN_suzu4kttTqeKTRv9O6mifA www.…
-
Files and File Links on Google Drive
Every job I do, I have to store one or more artwork files on Google drive. This involves creating a Customer folder ( ie ABC Limited) and then creating 1 or more individual Job file folders (ie comp…
-
Upper case characters
Has anybody a solution of how to change all fieldnames in the DB to for example upper case characters. ? rgds Leo
-
Displaying external Dropbox images. The solution if your database contain many pictures to keep the database size small.
Pictures say more than words... Steven
-
How to create a button that clicks through forms
I'd like to put a button on the first tab of my form that, when clicked, opens the next record down on the table. The same as using the down-arrow on the keyboard.…
-
Link a subtable to a phantom table
I've been stuck on this script since last night. I want to create a phantom table from the Quotes table and the Prices sub-table. Everything works fine,…
- Answered
-
csv export problem.
'Ver Archivo CSV' := null; let xMd := 'Busqueda por Mes'; let registros := select 'Datos Transferidos' where month(Date) = xMd; let csvContent := "Cliente,Date,Transferido Dato 1,Transferido Dato 2,…
- Answered
-
POST multipart/form-data query to external API
Hi everybody, I need to post data to an external API who accept only "Content-Type: multipart/form-data". Ninox http function seem able to send only "Content-Type: application/json".…
-
Scripting
do as transaction ... end | do as server ... end | do as deferred ... end Ninox executes scripts in a perpetual exchange between the browser or app and the server.…
-
Create your own functions
Create your own functions with Ninox to automate workflows according to your needs Advantages write a script once and use it throughout the database concise scripts because you only need your own…
-
Repeat conditional statements with loops
for ... in ... do ... end | for ... from ... to ... do ... end | while ... do ... end Loops allow you to automatically execute a code block multiple numbers of times in succession.…
-
Sort records
order by Use order by to sort an array of records by a specific field. This is useful when sorting an array first before processing it further. When you use order by in a View layout item,…
-
Creatable if and Deletable if
The Ninox 3.11 release introduces "Creatable if" and "Deletable if" — set conditions for record creation and deletion with the formula editor ✅ Creatable if and Deletable if are available for all…