-
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.…
-
Tips and tricks
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
-
Option A: without a custom script
Follow CamelCase and underscore notation in template Without a custom script, your template (e.g., a DOCX file) must follow the proper notation for field names.…
-
Upload a template
The first step to creating and rendering a report is to set up a new print layout in Ninox Create a new layout and import file Open a database to open a table that contains records you want to print.…
-
Create a template
Get from a document in a text editor to a printable report in Ninox Open a text editor, e.g., Microsoft Word, LibreOffice, Open Office, Google Docs, or other. Choose the type of template you want.…
-
Introduction to dynamic print layouts
Learn the basics of print customization in Ninox Availability ✅ Print customization is available for Public and Private Cloud starting 3.7.7. Capacity The pricing page (section on Essentials) offers…