Types / Tables

Tables hold a collection of related items. You can think of it like an Excel spreadsheet or database table. You might have a table for orders, customers or products.

Viewing Table Data

There are two ways we display tables in Snapboard.

1. Tables displayed visually

The special Data Card provides a visual representation of your data. You'll find the Data Card's used in the imports section of Snapboard.

2. Tables displayed as JSON

JSON is another way of displaying values, that is easy to read for both computers are humans. Here's the same information as above, but displayed as JSON.

[
  { id: 1, name: "Calum", age: 25 }, 
  { id: 2, name: "Jane", age: 22 },
  { id: 2, name: "Sam", age: 22 }
]

Manipulating Tables

If you want to transform the values in a table, then you can use a Map function. The Map function will go through each item in the table and apply a transformation that you specify to each item.

Below, we're going to use a Map function on the table above using

Map(table, UpperCase(name))

The above would result in a transformed table like the one below - notice that the name field has been capitalised to uppercase.

[
  { id: 1, name: "CALUM", age: 25 }, 
  { id: 2, name: "JANE", age: 22 },
  { id: 2, name: "SAM", age: 22 }
]
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.