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.

Since we only need to display the following fields for the invoice:

• Description
• Quantity
• Unit Price and
• Total

we will adjust the subtable accordingly.

Additionally, we will also add the calculation of the Total Sum.

                                                                     Current View

How it works

1. We open the edit mode  in the table Invoices.
2. Click on No. in the subtable, and a pop-up will open.
3. Select Hide Column.
4. Also hide Invoice No..
5. Resize the field Descriptionby dragging the divider to the right.

 Double-click on the column header to display the pop-up. Then click "Hide Column" for each.

Insert Total Sum

1. Click on Totaluntil the pop-up opens.
2. Click on Sum.
3. Now all amounts that we will soon enter into our invoice will be automatically added, and the invoice amount will be displayed.

Use the built-in Ninox options to add the automatic sum

We now need to configure the fields in the subtable. Let's continue!