-
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.… -
Docker installation
Prepare an environment with Docker. Refer to the Docker's Orientation and setup guide for more information.
Content in curly brackets { } signifies a placeholder.… -
Windows Server installation
Prepare an environment with Windows Server. Refer to the Get started with Windows Server guide for more information. System requirements Supported operating systems Windows Server 2008 or higher…
-
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.…
-
API endpoints for Public Cloud
All available Ninox Public Cloud API endpoints
Content in curly brackets { } signifies a placeholder. Both the curly brackets and the content within must be replaced for the request to work.… -
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".…
-
Optimize performance of scripts
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.…
-
OIDC SSO with Okta
Set up SSO for your Ninox server (Private Cloud or On-Premises) using OIDC and a third-party app like Okta
SSO is an Enterprise feature available on request that requires a valid license purchased… -
SAML SSO with Azure AD
Setting up SSO for your Ninox server (Private Cloud or On-Premises) using SAML and Azure Active Directory
SSO is an Enterprise feature available on request that requires a valid license purchased…