5-Column Data Table with Sortable Fields

Overview

This module allows a user to view a list of things in a data table format with header texts. Columns will hide as the screen size shrinks. You can sort the list by clicking the sort icon in a column header.

Structure

• When this module is added to a page, it is placed within a group called Group page860Group on the page. This group contains the responsive settings for all modules.

• This module Group 5ColumnDataTableWithSorting contains three main groups:

  • Group verticalPadding 1 - For responsiveness (please do not delete)

  • Group verticalPadding 2 - For responsiveness (please do not delete)

  • Group 780StandardGroup - If you add more elements to the group, please ensure that they are contained within this main content group.

• RepeatingGroup sortingRepeatingGroup contains the list of things (you should update the data source). This repeating group has two states:

  • Sort descending? - A yes/no field with a "no" default value (you can change this based on your preference)

  • Sort field name - A text field used in RepeatingGroup sortingRepeatingGroup to sort the data dynamically (make sure to change the default value here based on your preference)

When you sort a list by a dynamic field, the field name you provide is case sensitive and it must match the field name on the list's data type.

How to set up

• Go to the page where you have added the module and updateRepeatingGroup sortingRepeatingGroup's data source

• Update the default values of RepeatingGroup sortingRepeatingGroup's two states

• Update header text and the data source of the texts in the module.

• Update the workflows triggered by the sorting icons in the column headers, so they can sort the list by the correct fields

• Remove Button ADD or add a workflow to the button

How can I add or hide columns?

You'll want to check which columns you want or don't want hidden as the screen width decreases because there are hiding rules on columns 3 through 5. If you only want certain columns to show on mobile, you should go to the responsive editor and add or remove hiding rules to both the header text and data text (for the column that you want to hide). Make sure they have the exact same responsive settings (hiding rule with, minimum width, maximum width, responsive alignment, and width).

• Go to the page where you have added the module and in the Bubble Editor click on the Responsive tab next to UI Builder

• Using the ruler at the top (<-->), adjust the page width to the width that you want the column to hide at

• Click on the element or column you want to hide at that page width and check the settings for hide when parent width <= WIDTH

  • The same hiding rule should be applied to both the header text group and text in the reusable element in order to hide the entire column

You can further customize the data table by removing columns that you do not need. If you do edit the columns, please make sure that the header and data texts all align (start at the same x position), nothing is overlapping, and all the responsive settings for the header texts and data texts match exactly (hiding rule with, minimum width, maximum width, responsive alignment, and width).