-
What is an application?
Applications, often simply called apps, are complete, self-contained computer programs developed for end users. Applications perform specific and useful tasks that have nothing to do with the IT…
-
Introduction
We show you, step by step, everything that Ninox can do To create your own applications, whether it’s an invoice management system, event calendar or customer management solution (CRM),…
-
Formula editor features
An overview of all basic features the formula editor offers as of version 3.6.0
At the moment, the new formula editor features are available for the web app (app.ninox.com) as well as the Mac app.… -
Introduction to Ninox script
The Ninox script language (also "NX script language" or "NX script") is designed to automate simple, repetitive operations, as well as complex work sequences,…
-
Date and time formats
Token Description Example YY Year: 2 digits 21 YYYY Year: 4 digits 2021 M Month: 1 or 2 digits 1 … 12 Mo Month: ordinal 1st … 12th MM Month: 2 digits 01 … 12 MMM Month: 3 characters Feb MMMM Month:…
-
Icon picker
Find the name of each available icon in Ninox
In version 3.12 we introduced a new icon library and an updated icon picker. 
When you update from version 3.11 to 3.… -
Color picker
Updated colors and a new color picker in 3.12
In version 3.12, we introduced more options for color input, a new color palette, and an in-built color picker.… -
Intro to "any" functions
Below is info on how we use the "any" data type here in our Ninox guidance, specifically in the syntax of our functions "any" functions are a bit different Values of the data type "any" as well as…
-
Automatic adjustments
Ninox automatically makes the following adjustments for you Braces Ninox script automatically removes superfluous braces in expressions. For example, 1 + (2 * 3) is saved as 1 + 2 * 3.…
-
Intro to transactions
In Ninox, all actions are performed as transactions. In doing so, a sequence of database operations is summarized in a transaction. We distinguish 2 types of transactions in Ninox:…
-
Picture example – Word document
Prepare a dataset with a public URL or a Data URI corresponding to the image URL "image": "http://link.to/you/picture" } Data URI { "image": "data:image/png;base64,…
-
Picture from a Base64
This feature may not work at the time of release. Use picture from a public URL in the meantime. We will update this page once it becomes available.… -
Picture from a base64 Data URI
This feature may not work at the time of release. Use picture from a public URL in the meantime. We will update this page once it becomes available.… -
Substitutions
To substitute data in a template, use indicators {d.}. Indicators {d.} are substituted for data from your JSON dataset in Ninox. The following values can be substituted: a string a number a date
-
Deleting tables
Be careful when deleting tables. Depending on the structure of your database, information from a table might be used in other places as well To prevent you from “accidentally” deleting a table,…
-
Extra: Display options in the Choice field
You have various options for displaying the different choices in the form You can display the options stored in a Choice field in 3 different ways. On the left you can see the display options:…
-
Customizing data fields
You can customize the options for a data field to suit your needs. For example, you might want to specify that a field must always be filled in, i.e. that it’s a required field.…
-
Editing after saving changes
How to return to the table settings after saving Before we save the changes, we would like to make a few updates. You’ve already clicked the Save button?…
-
Adding and naming fields
A table consists of several fields, each of which holds information of the same type We will now create a form with various fields in which we want to enter our data.…
-
Adding a table
We will create a new table in a database Now we will continue working with the Event Management database that we’ve just created. Our “Event Management” database that we’ve just created Tables We…
-
Read transactions
To find specific records in a table using a filter, Ninox searches the table for records that match the filter. During this process Ninox only "reads" the table in order to display the records that…
-
Write transactions
When you change data within an action, this is referred to as a write transaction. Examples of write transactions The input or modification of data Single statements of a script that change data, e.g.…
-
Execution context
do as database ... end is available for Private Cloud/On-Premises Ninox executes transactions either in the client or on server. On one hand, which transaction is executed on server or in the client…
-
Tips and tricks for fast databases
Learn how to boost the performance of your databases First, a checklist of common questions and advice:
What are the potential bottlenecks? A look at the process monitor helps identify areas for… -
Automatic invoice number
Use this script to automatically assign an invoice number An invoice number... must be unique and should be sequential, can consist of numbers and letters,…