A list view is used to display multiple records from your database.
How Lists Work
Lists display multiple records from an object in your database using a flexible layout of rows.
Any of the fields from that object can be used as details in the list.
Each record in a list can be linked to a child scene to edit or view more details about that record.
Add Lists
Add a list to display object records
You can add a list to display records on any entry page by selecting the List option from the views toolbar at the top of the page:
Select the object you want to display records from, and click the "Add list" button:
Then you can select additional options to add links to view or edit each list record in a new page. Last, click the "Add view" button:
You can add links to edit each record with a form or view more details about each record.
You'll also have options to display any connected records. In the example above each company is connected to many contacts, so options are available to display those connected contacts or add a new one.
Add a list to display connected record
If your app is using connections, you can add lists to display connected records to any page displaying details about the parent record.
For example, in our Contact Directory example app, you can add a list on a Company details page to display Contacts connected to that Company.
Select the List option at the top of any details page. Then select the connected object from the "Records connected to this page's Company" list:
New lists will include the first six fields of the object by default.
Edit Lists
Click directly on a list in your pages to edit it:
The list will open in "edit" mode where you can use the menu on the left to edit different aspects of the list.
Data Source
The Data Source section is used to control the records the list will display. A filter icon to the right of the Data Source title indicates if filters to restrict the data being displayed on your view have been applied:
-
Data: the table will display all the object's records by default. Use the data section to add rules to limit which records will be displayed.
-
Sort: control the default sort order of which records will be displayed first.
-
Limit: show all the available records or limit to a specific number.
Click here for more on working with the data source.
List Details
The List Details section determines which fields the list will display for each record. This follows the same model as the Details view.
Click here for more on editing the list details
Options
The Options section provides additional options for formatting your list. Options here include:
- Set how many records to show at a time
- Let the user set how many records to view per page
- Show pagination controls at bottom of list
List Layout
The list layout allows you to display your list in 1, 2, or 3 columns.
Pagination
Pagination determines how many records will show at one time. If the total number of records exceeds the number set here, then links will be added to the list to navigate to additional pages, displaying more records.
The Options section contains four features that you can enable to customize your list view:
- Set how many records (10, 25, 50, or 100) to view at a time
- Let the user set how many records to view per page: This allows the user to change how many records they are viewing per page.
- Show pagination controls at the bottom of the list: this will display pagination controls at the bottom of the list as well as at the top. By default this will be the "page X of X" display. If the feature to allow users to set how many records to view per page is enabled (see previous bullet point) this option will also show at the bottom of the list.
Keyword Search
Displaying a keyword search will present a search field above the table for the user to enter keywords to filter which records will display. These keywords will search the entire record.
On the search results display, a “reset” link will appear. Clicking this will reset all search criteria to easily search again with new criteria.
Note: the keyword search will be combined with any rules added to the Data Source section.
Exporting
Enabling exporting allows the user to export all the data from the list into another format. An export link will appear in the top left, with options for downloading in a CSV, Text, or JSON format:
Note: the exported data will always reflect the exact data the list is displaying, including any sorting and filters.
Record Filters
Filters give the user tools to further refine which records the table will show. You can add filters as options for the user to add, or as a menu.
User Filters:
Enabling user filters presents options for a user to add any filters they'd like to the list. This will then display an "add filters" link above the list:
The list will update as soon as a filter is added. Multiple filters can be added as needed.
You can determine if the fields available to filter are limited to the table columns or all the object fields. You can also add preset filters that will initially filter the records.
Filter Menu:
Enabling a filter menu will present links above the table the user can click that will filter the records based on the rules you create:
The user can then click on the menu links to automatically filter the records:
Note: if you added rules to the list's Data Source (see above), those rules will be combined with any filters that are added.