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.
-
Hover over the column, and click its caret (βΌ) button.
This will open the column's menu. -
From the menu's Transform submenu, select Set link.
This will open the Set Link modal. -
Under Link SourceΒ select Custom Formula.
-
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.
-
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.
-
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:
-
Hover over the column, and click its caret (βΌ) button.
This will open the column's menu. -
From the menu's Transform submenu, select Set link.
This will open the Set Link modal. -
Under Link Source select Another Column.
-
Under Select column, select the column containing the URL.
A preview will appear under URL Column. -
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.
-
Click your target column's caret icon to open its column menu.
-
From the menu's Transform submenu, select Set link.... This will open the Set Link modal.
-
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.
-
Select the column you would like to add a URL to or create a new one.
-
Using the formula bar and Sigma's Concat function, structure the column's URLs.Β
Example:Concat("https://www.plugs-electronics.com/location/", [Store Id])
-
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:
-
Click the column's caret icon to open the column menu.
-
Select Transform > Set image....
-
In the Set image options modal, turn on the Display as image toggle.
-
Specify the image sizing, height, width, and whether to preserve the aspect ratio of the image.
-
Select Save.
Images appear in the table cells.
Updated about 1 month ago