Footballers Lookup

Use this form to search for footballers.

There are two components which have been placed on this form using the App Studio forms designer.

Filter Footballer Criteria

This component is linked to 3 ReST API data sources which are used to populate the drop down combo/list for each of the lookup fields: Club, Nationality and Position. A 4th field is a text field allowing end-users to search for a footballer by name. Users can uses as few or as many filter fields are they require. The Apply button populates the grid.

Footballers Grid

The grid reads all of the footballers/players in the associated ReST API dataset and presents them in tabular format. This dataset contains the name and photo of the player, nationality and flag and club and badge, together with position and squad number.

You can type text into the enabled filter rows to narrow down your lookup.

The grid footer tells you how many footballers there are in this grid. Each footballer is a row, or a record in database language. Each group of records is effectively a page, and the number of records/rows per page can be changed to display more data as required.

Clicking on the footballer name will 'drill-down' and open the footballer form, likewise clicking on nationality or club will drill-down into their respective forms also.