-
Icon picker
Find the name of each available icon in Ninox
In version 3.12, we're introducing 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're introducing 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,…
-
Picture from a public URL
The following dataset is used in the example below that shows how to insert a picture into an ODT report Data { "flags": [ { "name": "France", "picture": "https://share.ninox.…
-
Password encryption
If needed, encrypt a rendered report with a password Either toggle ON the option Set password in the Ninox UI, or alternatively use a custom script and the functions printRecord or printAndSaveRecord.…
-
Formula returning a record causes type mismatch
I have a formula that returns a record. This formula works fine. But whenever I try to use the returned record in a then or else branch, I get a type mismatch. The formula field is OrderItems.…
-
Create new record in another table and transfer all fields across
Hi, I have created a table that I am using as a "kiosk" type function where external parties can enter their form details. Once they click on a button called "Sign In" I want that data to transfer…
- Answered
-
Using Ninox ChatGPT to create a search
Hi, My first shot at creating a button to search a field (RTF) to find and mark results. I have a field SEARCH for the search terms and the RTF field is NOTES.…
- Answered