Searchable table with links
The table function can come in handy if you want provide a simple service to allow readers to search for relevant data and click to get more information.
The following table shows a simple proof of concept:
Follow the steps below to create this table.
Prepare the data in Google Sheets
We have created a new Google spreadsheet consisting of three columns
Column A: The video description
Column B: A Human readable Link that we will use in the table
Column C: The actual URL for the video on Youtube
There's nothing special about this, except for column B. Instead of showing a cryptic Youtube video URL, we prefer to have a human readable link. The Column B is simply using a built-in formula in Google Sheets called HYPERLINK
The formula will construct a hyperlink consisting of the URL from cell C2 and the text "Play video". When this is created, you can copy the formula to all other cells in this column.
Create the table in everviz
Follow this document to learn how you can create the table in everviz
Copy the first two columns from your Google Spreadsheet and use the paste option in everviz when creating the table
Note! A CSV upload or Google Sheet connection would truncate the formatting and cannot currently be used when creating tables with hyperlinks