Overview

Record List form widgets are added from a form page’s Add Widget menu.

A record list widget is a scrollable table with one row for every record in the dataset.

You can search by typing a phrase in the Find field on top. Here we’re searching for “sherm” and the record list widget is showing the 5 records that include that phrase in any of the fields that are showing.

Choosing columns

You can choose which fields to show columns for in the record list widget’s Edit dialog. Here we’ve also marked the Country column as editable.

This is what that record list widget looks like when using the form. In this example we’ve changed Abbey Sovey's country to Armenia, and we can either Save or Cancel the change. By making one or more columns Editable, you can make changes to many records quickly.

Sorting

When no sorting is set, records are sorted alphabetically by the first column. To set default sorting, choose a sorting option next to one or more columns. When multiple columns have sorting enabled, the widget sorts from left to right—first by the leftmost sorted column, then by the next, and so on.

While viewing a record list, users can click any column header to sort that column. Click once for ascending, twice for descending, and a third time to return to the default sort. A small arrow indicates the current sort direction.

Action buttons

You can also choose to have action buttons on rows by choosing "Actions Button Text" and assigning a Button Click action. In this example we’ve set the action button text to "Edit Customer", and we’ve set the action to go to the Customer Details page. See the Form Variables, Logic, and Actions article for more information.

Now when we click an Edit Customer button, the form will go to the Customer Details page for that record. It’s very common to use the record list widget like this to choose which record you want to view or edit.

Record filters

You can change which records show in the record list widget by adding a record filter in the widget’s Edit dialog. Here we’re choosing to only show records that were manually added, but you can apply any of the dataset filters that are used throughout Spider Impact, like "Record is Editable".

When we use the form we now only see the records that were manually added. This can be very helpful when using a form to add and manage only a dataset’s supplementary records.