Add hyperlinks to columns

Hyperlinks can be added to any column in a table or pivot table. This option is available from each column's menu, under Transform > Set link.

Requirements

  • To use this feature, you must have Can Explore or Can Edit access to the individual workbook.

Add a Hyperlink

Add a Hyperlink from a Formula

Before you start: This action uses the editor panel. If you have not done so already, open the editor panel from either Explore or Edit mode.

  1. Hover over the column, and click its caret (▼) button.
    This will open the column's menu.

  2. From the menu's Transform submenu, select Set link.
    This will open the Set Link modal.

    Screen_Shot_2022-02-03_at_12.45.08_PM.png

  3. Under Link Source select Custom Formula.

    Screen_Shot_2022-02-03_at_12.48.41_PM.png

  4. Under Create URL with formula, use Sigma's Concat function to structure your target URL. You can inject columns exactly as you would with Sigma's standard formula bar.
    Example: Concat("https://www.plugs-electronics.com/location/",[Store Id])

    Note: Any column can be injected into the formula.

    Screen_Shot_2022-02-03_at_12.51.30_PM.png

  5. Press Enter on your keyboard or click the green checkmark icon to the right of the formula bar to apply the formula. A preview will appear.

    Screen_Shot_2022-02-03_at_12.53.34_PM.png

  6. Click Set Link.

Add a Hyperlink from an Existing URL Column

Prerequisites:

  • This method requires that you already have a column with working URLs. It will apply the URLs from the source column as hyperlinks on the values in your selected column.
  • This action is only available in edit mode. To begin editing, click Edit in the top right corner of the page.

To add a hyperlink from an existing URL column:

  1. Hover over the column, and click its caret (▼) button.
    This will open the column's menu.

  2. From the menu's Transform submenu, select Set link.
    This will open the Set Link modal.

    Screen_Shot_2022-02-03_at_12.45.08_PM.png

  3. Under Link Source select Another Column.

  4. Under Select column, select the column containing the URL.
    A preview will appear under URL Column.

    Screen_Shot_2022-02-03_at_1.01.13_PM.png

  5. Click Set Link.

Remove a Hyperlink

Before you start: This action uses the editor panel. If you have not done so already, open the editor panel from either Explore or Edit mode.

  1. Click your target column's caret icon to open its column menu.

  2. From the menu's Transform submenu, select Set link.... This will open the Set Link modal.

  3. Click the Remove button located in the modal's footer.

Create a Linked URL Column

This method results in full URLs being displayed in your column's cells. To display text only with a clickable hyperlink, follow the instructions above to Add a Hyperlink.

Before you start: This action uses the editor panel. If you have not done so already, open the editor panel from either Explore or Edit mode.

  1. Select the column you would like to add a URL to or create a new one.

  2. Using the formula bar and Sigma's Concat function, structure the column's URLs. 
    Example: Concat("https://www.plugs-electronics.com/location/", [Store Id])

  3. Press Enter on your keyboard or click the green checkmark button to the right of the formula bar.

Display Images from Links

You can render images from a link to display images in table cells.

Prerequisites:

  • This method requires that you already have a column in your data with links to the images.
  • This action is only available in edit mode. To begin editing, click Edit in the top right corner of the page.

To display images from links in a data column:

  1. Click the column's caret icon to open the column menu.

  2. Select Transform > Set image....
    Image showing described steps.

  3. In the Set image options modal, turn on the Display as image toggle.

  4. Specify the image sizing, height, width, and whether to preserve the aspect ratio of the image.

  5. Select Save.

    Images appear in the table cells.