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 popup will open.
3. Select Hide column.
4. Also hide Invoice No..
5. Resize the field Description by 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 Total until 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!