2 - Create Forms

Last updated 26/05/2025

This documentation will explain the forms you will need to create using the new tables you added in the Portfolio application. With these forms, you will see how to position the forms under a parent menu to understand how Five filters the data for you.

Navigate to the Form Wizard

1. Click Visual in the menu.

2. Click Form Wizard in the sub-menu.

Figure 1 - Form Wizard menu item

Add the Buys Form

The Portfolios menu will become the parent for the Buys menu. By making Portfolios the parent menu, the Buys menu will be accessed in the Portfolio application under a selected portfolio record, hence the buy records will be filtered to the selected portfolio record.

1. Click the lookup icon in the Main Data Source field and select Buy.

2. Click the lookup icon in the Parent Menu field and select Portfolios.

Figure 2 - Add Buys form

3. Click the Next button.

Figure 3 - Next button

4. Click the List checkbox for the StockKey field.

5. Click the List checkbox for the TransactionDate field.

6. Click the List checkbox for the Quantity field.

7. Click the List checkbox for the Total field.

Figure 4 - Buys fields

8. Click the Save button in the Form Wizard app bar.

Figure 5 - Save button

Add the Sells Form

The Portfolios menu will also a parent to the Sells menu.

tip

You could use Five's copy feature here just the same as we did at the table-level, however, for this particular scenario the Form Wizard will be quicker as the wizard will create the Sells menu item as well!

1. Click the lookup icon in the Main Data Source field and select Sell.

2. Click the lookup icon in the Parent Menu field and select Portfolios.

Figure 6 - Add Sells form

3. Click the Next button.

Figure 7 - Next button

4. Click the List checkbox for the StockKey field.

5. Click the List checkbox for the TransactionDate field.

6. Click the List checkbox for the Quantity field.

7. Click the List checkbox for the Total field.

Figure 8 - Sells fields

8. Click the Save button in the Form Wizard app bar.

Figure 9 - Save button

Add the Allocations Form

1. Click the lookup icon in the Main Data Source field and select Allocation.

2. Click the Add Menu Item switch.

Figure 10 - Add the Allocations form

3. Click the Next button.

Figure 11 - Next button

4. Click the List checkbox for the BuyKey field.

5. Click the List checkbox for the Quantity field.

Figure 12 - Allocations fields

6. Click the Save button in the Form Wizard app bar.

Figure 13 - Save button

Navigate to Forms

We will need to go to the Forms view so that we can edit the Sells form to add an Allocations page. This will enable us to allocate shares for a sale.

1. Click Visual in the menu.

2. Click Forms in the sub-menu.

Figure 14 - Forms menu item

Edit the Sells Form

1. Select the Sells record in the list.

2. Either click the Edit button in the form app bar, or click directly in the Page Navigation field.

Figure 15 - Edit button

3. Click the lookup icon in the Page Navigation field and select Continuous.

info

Selecting Continuous as our page navigation will give the Sells form a different look from the previous forms we have made. Tabs will not be displayed across the top of the form, the form will flow in a continuous manner instead.

Figure 16 - Page Navigation field

4. Click the Pages tab.

Figure 17 - Pages tab

5. Click the Add Pages button.

Figure 18 - Add Pages button

6. Type Allocations in the Caption field.

7. Click the lookup icon in the Page Type field and select List.

8. Click the lookup icon in the Action field and select Allocations (Form).

Figure 19 - Add the Allocations page

9. Click the Save button in the form app bar.

Figure 20 - Save button

10. Click the Save button in the form app bar above the list.

Figure 21 - Save button

Deploy the Portfolio Application

tip

This is a good time to deploy/run the Portfolio application to see the changes and what we can improve.

1. Click the Deploy to Development or Run button in Five's toolbar.

info

If your application has dropped out due to inactivity, click the Remove from Development button and redeploy your application again.

Figure 22 - Run button

Test the Buys Form

To navigate to the Buys view, a Portfolio record needs to be selected in the list for the Down button to be available which will take you to the menus under the selected Portfolio record.

1. Select the Growth Portfolio record.

2. Click the Down button in the form app bar.

tip

You can customize the Down button!

Figure 23 - Down button

info

You will be positioned on the Buys form. Lets add some test data and see what we can improve!

As the Portfolios menu was set as the parent for the Buys and Sells menus, you will only see the data related to the selected Portfolio record when drilling down.

1. Click the Add Item button.

2. Click the lookup icon in the Stock field and select AEI.

3. Click the calendar icon in the Transaction Date field.

Figure 24 - Add a Buys record

4. Select today's date and click the OK button.

Figure 25 - Select current date

5. Type 100 in the Quantity field.

6. Type .50 in the Price field.

7. Type 10.00 in the Fees field, press Tab.

Problem

The Total field does not automatically calculate the total, this is not ideal! In Five, we can add a function to fix this.

Figure 26 - Total field

8. Click the Cancel button in the form app bar.

Figure 27 - Cancel button

9. Close the browser tab and return to Five.