Show Data in a Table on a Flexcard

At times, a sortable table is most suited to represent your data. You can show data retrieved from a data source in a table on Flexcards. For example, show account cases as a sortable table.

1. From the App Launcher, find and select Flexcards.
2. Expand a Flexcard and select a version.
3. If needed, deactivate the Flexcard for editing the Flexcard.
4. Drag the data table element from the element panel to the canvas.
5. Configure the newly added table element:
   1. Add columns in the data table and enter information as needed in the window that appears.
   2. To let users navigate between pages using numbered links in the page, set up pagination properties by using the Page Size and Page Limit fields.
      If the page size is not specified, all records are displayed in a single page. If the total number of pages in the data table is less than the page limit, all pages are shown in the navigation links.
      For example, if you set the page limit to 3, each page displays three numbered links at the bottom of the page. The first and last pages are always shown in the navigation links. Any remaining pages are shown as ellipsis.
   3. To delete a record when a user sets a field value to false, enter a field name in the Field Determining Row Deletion field. If you're using the designer on a managed package, enter a field name in the Row Delete Dependent Column field.
      Make sure that delete row is enabled for the data table.
      For example, a table lists account cases and has a boolean record field IsEscalated. When IsEscalated is false, a user can delete the record. When the field is true, hide the trash icon to prevent users from deleting the record.
   4. Enter the remaining information as needed.
      

      Note If you hide a field by using the Is Visible attribute, a user can't search the column associated with the field, even if the Is Searchable attribute is set to true.

   You can't add a clickable field in a data table. As a workaround, select the User Selectable Row attribute, which triggers a rowclick event. Then, in the Flexcard, add an event listener that uses a merge field action that contains the row data. You do this by clicking Event Listener in the Setup tab of the Flexcard. The merge field must be in the {action.result.X} format, where X is the fieldName from the data table. This action fetches data into the data table.