-
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…
-
Create and delete records
create | delete create To create a record in a specific table by script, specify the corresponding table name in a button after create. Example create Customers Result: A new,…
-
Fields
Find out more about the field types available in Ninox A field represents a location stored within a row of a table in a database. When creating a table in Ninox,…
-
Ninox languages
The following languages are supported by the Ninox app. This may be relevant when working with a specific date or time format. Specific languages supported by Ninox Abbreviation Language de German en…
-
save archive NOT IMPLEMENTED
Good day when I try to save archive as from cloud to my mac it shows up a message NOT IMPLEMENTED. how can I resolve this? Thanks
Top Contributors
Last Month