Tables Category

Tables
Tables are the basic building blocks of a database and contain its records

  • 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.…

    • updated 1 yr ago
    • 1534
    • Tables

  • 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…

    • updated 4 mths ago
    • 663
    • Tables

  • 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…

Back to top