Cards: Display Table Data

This article provides the instructions to create and configure a Table card, which allows you to display data or quantitative information in a structured table, either by manually adding the data into the table, or importing it from an Excel spreadsheet.

The following features and customizations are available on the Table card:

  • Manual data input or from an external source using a URL.
  • Table title, header and body customizations.
  • Background color and media support.
  • Custom row height and column width settings.
  • Conditional formatting.
  • Column sorting.
  • Data filtering.
  • Table pagination, with transitions and custom durations.
Note
A completely redesigned Table card is made available on October 18th 2019. The Table card is now an Appspace Supported card, which will be periodically updated by Appspace with new templates and features.

Existing Table card templates (prior to this release) which were categorized as Community Cards will be removed from the Appspace console.

Important
Please refer to our Introduction to Cards guide for an in-depth introduction to the types of cards that are ideal for your signage solutions.

Visit our Appspace Card Gallery to find the perfect card to deliver your message.

This article provides instructions on how to create, configure, and customize the Table card.

What’s in this article:

Prerequisite

Create and Configure Table Card

The instructions below allow you to create a table in Library.

  1. Log in to the Appspace console.
  2. To create this card, select one of the following options:

    • Click +QUICK ACTION from the Appspace menu bar on the top right, and select Create Content.
    • Click Library from the ☰ Appspace menu, and select a library or folder you wish to create the content in. Click +CREATE, and select Content.
    • To create and add the card directly to an existing channel, refer to Add Content to Playlist Channels.
  3. Select Data from the All Templates drop-down menu, and click Table.

    Important
    If you are unable to locate the content, try using either the Search bar, the Order by, or Filter icon to narrow down the content that you are looking for.
  4. In the Edit tab;

    • Enter the Title of the content as this will also act as the filename for the content. This is a mandatory field.
    • Enter the Title of the table. Use the Text Editor to customize the text font and style.
    • There are two options to populate data into the Table card, select your preferred option:
      • URL (External Data Source) 
           
        Important
        We support URL links to an array of array object, a CSV file, or an XLSX file. However, the .xlsx file format requires Appspace App 2.10 to work correctly, which is scheduled to be released on the 10th of April 2020. If a .xlsx file is used in the card, the card and the Appspace App will crash during playback.
        1. Enter in the URL link for the external data source ( array of object array, .csv, or .xslx )
        2. Select the Refresh URL, and enter in the duration in minutes.
          • Set Duration – Retrieves external data from the URL link provided depending on the duration set.
          • Card Reload – Reloads the entire Table card depending on the duration set.
      • Manual Input / Upload (Internal Data Source)
        1. Click the Add Data button, and populate the card’s table using one of the following methods:
          • Manually enter in data or an image into the table.
          • Copy and paste data from an external table.
          • Import data from an Excel spreadsheet (.xlsx).
              

            Important
            Only Table Card 1.1 and later support adding images to a cell.
    • Hover over the column to bring up the column inline controls, which allow users to:
      • Format Column – Enables individual column styling and text wrapping options for the selected column.
      • Conditional Formatting – Enables conditional formatting for the selected column.
        The following conditional formatting options are available:

        • Positive values
        • Negative values
        • Is empty
        • Is not empty
        • Greater than
        • Greater than or equals to
        • Less than
        • Less than or equals to
        • In range
        • Out of range
        • Text contains
        • Text does not contains
        • Text is exactly
        • Exactly
      • Highlight Column – Expands the selected column by using the remaining width of the table, once non-highlighted columns take on the natural width of the table.
      • Sort Column – Enables the selected column to be sorted either acsending or descending order.
        The acsending order is sorted based on the following sequence:

        • Empty value
        • Number
        • Date
        • Character
        • Media
      • Filter Column – Enables the selected column to display only the filtered records.
        The following filter options are available:

        • Positive values
        • Negative values
        • Is empty
        • Is not empty
        • Greater than
        • Greater than or equals to
        • Less than
        • Less than or equals to
        • In range
        • Out of range
        • Text contains
        • Text does not contains
        • Text is exactly
    • In the Design section; click the arrow to expand.
      • Customize the Header Styling and Body Styling, such as font, size, color, background.
      • Customize the Banner, and the Background color or image.
      • Upload a Logo.
    • In the Configuration section; click the arrow to expand.
      • Select the Row Height:
        • Auto
        • Fixed – Displays the Rows per page option, allowing users to set the number of rows to display in a page.
      • Select the Column Width:
        • Auto
        • Distribute equally
      • Select the Display Options:
        • Enable intro transitions
        • Enable auto paging
        • Enable table carousel
        • Enable word wrap
        • Enable row shading
      • Select the Page Transition
        • Continuous scrolling
        • Page-by-page
      • Select the Page Duration (Seconds)
        • 8 secs
        • 12 secs
        • 24 secs
  5. In the Article tab; This section may be skipped.
    • Include an Article or Caption to accompany the content item when being displayed on mobile apps, tablets, and other social collaboration apps.
    • Enter a Referral Link to link more information to the content.
  6. In the Schedule tab; This section may be skipped.
  7. In the Settings tab; This section may be skipped.
    • The Name field will be auto-populated to match the Title of the content which will also act as the filename for the content. This is a mandatory field.
    • Enter any relevant Tags for the content. (Optional)
    • Select a folder for the content in the Library Location drop-down menu to change the default folder location.
    • Select an expiry date for the content from the Auto Delete Content from Library drop-down menu. (Optional)
    • Upload an image to be used as the Thumbnail for the content.
  8. Once done, click SAVE.

Edit Table Card

The instructions below show you how to edit a Table card.

  1. Log in to the Appspace console.
  2. Click Library from the ☰ Appspace menu, and select a library or folder containing the content you wish to edit.
  3. Select and click the Table card to edit, and select the desired tab to edit or view.
    • In the Edit, Article, and Settings tabs:
      • You may edit the content the same way as it was configured. For detailed instructions on how to do this, please refer to the Create and Configure Table Card section above.
    • In the Preview tab:
      • Preview how the content is displayed on your device.
    • In the Channels tab:
    • In the Analytics tab:
      • View the individual content analytics in this tab. For more information, please refer to the Individual Content Analytics section of the Analytics article.
  4. Once done, click SAVE.
Related Articles