Skip to main content

Introduction

Last updated 13/03/2024

Five's Advanced Training Exercises​

This guide aims to take your basic knowledge of Five a bit further. It is expected that you have performed Five's Quick Start Guide exercises for the Portfolio application. The exercises in Five's Advanced section are an extension on the Portfolio application developed in the Quick Start Guide.

If you already have a basic understanding of Five and have not performed the Quick Start Guide, you can download and import the Portfolio.Focus.fdf and start building on top of this FDF to start the advanced training.

These exercises are not designed to be quick, they are designed to further help you to add functionality into your application and start to understand Five's API.

Below is a short video to show you how stage two of the Portfolio application developed in Five works.



All SQL syntax and code blocks are available by clicking on the Copy buttons throughout the documentation. Five's advanced exercises are built sequentially. It is highly recommended to complete all exercises before moving on as each subsequent exercise relies on the data established in previous exercises.

During the training you will be asked to run the Portfolio application in most of the chapters to add test data and see how we can improve the application in Five.

Throughout Five's advanced training you will learn the following:
  • How to use Five's SQL Editor;
  • How to work with parameters in Five;
  • How to use Five's Code Editor;
  • How to attach functions to events to be executed;
  • How to create parent menus;
  • How to work with Five's stack;
  • How to create charts with multiple data sets;
  • How to create action pages;
  • How to interact with Five's API.