Creating a List screen from scratch, using a SQL table

We are now going to list Service Logs on our home screen, ordered by the most recent logs - by Service Date.

To achieve this we:

1. Navigate to the home screen, under “Design”.

2. Remove any default components that are on the page.

3. Add a “Data Provider” component.

4. Give the data provider a name, so that we can easily identify it in our component tree (left panel).

5. Setup the data provider to connect to the “Service Log” table.

6. Set the “Sort Column” to “Service Date”

7. Add a table component, underneath the data provider

8. Finally, we select the columns that we want to see in the table