Guide to Converting Cell Data into Clickable URLs in Table Editor

Introduction

This feature allows you to automatically convert cell data into clickable links. For example, if a cell contains “TokyoStation,” it will be displayed as a link leading to a Google Maps search for that location.

Steps to Implement

Step 1: Access Column Settings

1. Open Table Editor and select the table you want to edit.
2. Select the column where you want to display data as links.
3. Click the “Style” button for that column.

Step 2: Add Code to the “Renderer” Field

1. In the column settings, find the “Renderer” field.
2. Insert the following code into this field:

'<a href="' + 'https://www.google.com/maps/search/?api=1&query=' + data + '" target="_blank">' + data + '</a>';

1. Explanation of the Code:
   • {data} will be replaced with the cell content.
   • href creates a search link on Google Maps.
   • target="_blank" ensures the link opens in a new tab.

Step 3: Save Changes

1. Click “Save” to apply the configuration.
2. Check the table to ensure the cell data is now displayed as clickable links.