-
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… -
SQL connection setup guide
Before you begin Request a license file from Ninox for your Private Cloud or On-Premises that is granted full access for one of these Enterprise features: mssqlConnections or pgConnections.…
-
Process monitor
Keep track of your Ninox activity, analyze and fix problems What the process monitor does The process monitor is a handy tool to observe what's currently happening in your workspaces.…
-
Defragment database
Optimize the structure of your database and increase its performance If you heavily work with your database, not only add but also repeatedly delete data,…
-
Tours
Get to know the Ninox assistant We use tours to interactively show you how Ninox works. The software we use for that acts as an additional "layer" on top of the app and guides you in real-time…
-
Independent tutorial
Explore printing, table relations and composition, roles and rights management, triggers, and connecting to Integromat
Note: The screenshots shown here might look a bit different from what you see… -
Intermediate tutorial
Learn how to reference tables, work with formulas, share your work, import and export data
Note: The screenshots shown here might look a bit different from what you see in your application but the… -
Tips
Use our Ninox assistant and video tutorials to learn more about using Ninox Ninox assistant (tours) If you haven’t met it yet, we would like to quickly introduce you to our Ninox assistant,…
-
Working together on databases
Invite colleagues to your workspace to collaborate with them on databases When you use Ninox in the cloud, you can collaborate with colleagues around the world on your database.…