-
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…
-
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.…
-
Customise sub-table
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.…
-
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.…
-
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.…
-
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:…
-
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…
-
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,…
-
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 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…
-
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.…
-
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.…
-
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.…
-
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:…
-
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.…
-
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.…
Tables are the basic building blocks of a database and contain its records