Skip to main content

2 - Create Forms

Last updated 13/12/2023

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.
1. Click Visual in the menu.

2. Click Form Wizard in the sub-menu.


Forms Menu Item
Figure 1 - Form Wizard menu item

Add the Buys Form

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.

info
By making Portfolios the parent menu for the Buys record, the Buys menu item will be accessed in the Portfolio application under a selected Portfolio record.

Add the Buys Form
Figure 2 - Add the Buys form

3. Click the Next button.


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.


Buys Fields
Figure 4 - Buys fields

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


Save Button
Figure 5 - Save button

Add the Sells Form

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.


Add the Sells Form
Figure 6 - Add the Sells form

3. Click the Next button.


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.


Sell Fields
Figure 8 - Sells fields

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


Save Button
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.


Add the Allocations Form
Figure 10 - Add the Allocations form

3. Click the Next button.


Next Button
Figure 11 - Next button

4. Click the List checkbox for the BuyKey field.

5. Click the List checkbox for the Quantity field.


Allocations Fields
Figure 12 - Allocations fields

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


Save Button
Figure 13 - Save button
info
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.


Forms Menu Item
Figure 14 - Forms menu item

Add the Allocations Page to 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.


Edit Button
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.

Page Navigation Field
Figure 16 - Page Navigation field

4. Click the Pages tab.


Pages Tab
Figure 17 - Pages tab

5. Click the Add Pages button.


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).


Add the Allocations Page
Figure 19 - Add the Allocations page

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


Save Button
Figure 20 - Save button

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


Save Button
Figure 21 - Save button

Run the Portfolio Application

tip
This is a good time to run the Portfolio Application to see the changes and what we can improve.

1. Click the Run button in Five's toolbar.

caution
If you are working in the Cloud and have not ran the Portfolio application for over an hour, your development deployment may have dropped out. You will need to click the Remove from Development button and deploy the application again.

Run Button
Figure 22 - Run button

Drill Down From the Growth Portfolio Record

1. Select the Growth Portfolio record.

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


Down Button
Figure 23 - Down button

tip
You can customize the Down button!

Test the Buys Form

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 and select today's date.


Add a Buys Record
Figure 24 - Add a Buys record

4. Click the OK button.


Select Current Date
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.

Total Field
Figure 26 - Total field

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


Cancel Button
Figure 27 - Cancel button

9. Close the browser tab and return to Five.