-
Databases and tables
Learn more about structuring and organizing your data Databases A database is a collection of data structured so that you can easily search for and retrieve items.…
-
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…
-
Open table settings
Your table is flexible. You can edit it at any time There are two ways to open the table settings in Ninox. Option 2 involves activating the edit mode, which also provides multiple editing options.…
-
Entering data
Of course, Ninox also allows you to import data, but in our example, we’ll first show you how easy it is to enter data directly into your form. There are 2 ways to do this:…
-
Selecting a record
We will explain the difference between an active and a selected record. Before we print an individual record, we want to clarify the difference between an active and a selected record record.…
-
Row numbers and IDs
In Ninox, there are 2 ways to number a row and/or record: The always visible row number The ID for a record (No.) Row numbers This is the row header. The row number is always displayed.…
-
Showing or hiding table columns
It’s easy to show columns — or hide information you don’t need. This gets even more interesting when it comes to creating different views. But more about that later.…
-
Sorting and filtering
Prepare your data to get the information you need quickly and easily You can apply standard sorting and filtering operations by clicking the respective column header.…
-
Sub-table (overview)
We take a detailed look at the subtable In the invoice form, open the subtable form by clicking on + Create record. Let's take a closer look at the subtable.…
-
Insert sub-table
All preparations are made – We are adding the sub-table. We will now create the sub-table in which we will enter all the consumption items. The invoice will display the total amount at the end.…
-
Customize subtable
Here you will learn how to configure the subtable according to your needs The subtable Invoice items is displayed in the form view of the table Invoices.…
-
Edit mode
Enable the wrench icon to edit your tables You can access the edit mode by clicking on the wrench icon which you will always see in the upper right corner.…
-
Rights at table level
In the table settings of a table, you can also set role-based permissions for that specific table. These include: Who can see the table at all (has Read access) Who can edit the table (has Write…
-
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?…
-
Printing tables
We have made all the preparations for printing a table. Depending on which format (PDF or HTML) you have selected, the following happens when you call up the print view:…
-
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,…
-
Creatable if and Deletable if
The Ninox 3.11 release introduces "Creatable if" and "Deletable if" — set conditions for record creation and deletion with the formula editor
Creatable if and Deletable if are available for all…