Create actions that navigate to destinations

Workbooks support actions that let users interacting with the workbook navigate to predefined URLs, other Sigma workbooks and documents, or different locations within the current workbook, including opening or closing modals.

This document explains how to create actions to navigate users to specific destinations. For more information about actions in Sigma, see Intro to actions.

User requirements

📘

The following requirements apply to users who configure actions. Users who access and interact with a workbook can typically trigger all existing actions within it. Any restrictions are noted in this document.

The ability to configure actions requires the following:

• You must be assigned an account type with the Full explore or Create, edit, and publish workbooks permission enabled.

• You must be the workbook owner or be granted Can explore¹ or Can edit workbook permission.

1 If you’re granted Can explore workbook permission, you can configure actions but cannot save changes to the workbook’s published version.

Open a link

Create an action that navigates to an external link or destination within Sigma. Open a static link or generate a dynamic URL that adjusts to control or column values in the current workbook.

1. Open a workbook in Explore or Edit mode.

2. Select the element you want to trigger the action, then click Actions in the side navigation.

3. In the Actions panel, click Add action within an existing sequence, or click Add action sequence to start a new sequence.

4. In the Action modal, configure the required fields to define the response:

   Action	Select Open link.
   Link URL	Enter the URL of an external webpage or destination within Sigma. For information about using dynamic text in the URL, see Create a dynamic URL in this document.
   Open in	Select an option to determine how the link opens in the browser. New window: Opens the link in a new browser window. Same window: Opens the link in the current browser window when the user interacts with the trigger element directly in Sigma. Parent window: Opens the link in the current browser window when the user interacts with the trigger element in an embed. The interacting user’s browser settings may change the selected Open in behavior. For example, New window may instead open the URL in a new tab (same window), and Same window may instead open the URL in the same tab.

5. If your trigger element is a table, pivot table, or input table, select a column in the When selecting cells in field. The action sequence triggers only when the user selects cells in that column.

6. [optional] If you want the action sequence to execute only in certain circumstances, click More, then click Add condition. See Make an action conditional for more information about action conditions.

Open a link with a dynamic URL

To generate a dynamic URL that adjusts to control or column values in the current workbook, utilize Sigma’s dynamic text functionality when configuring the Link URL field in step 4 of the previous section.

1. In the Link URL field, enter the base URL (unless this must also be dynamically generated), then enter = anywhere you want to add a dynamic value.

2. When you enter = , Sigma immediately displays an overlay containing a formula bar. Enter a control ID, or the title and column of an element, enclosed in square brackets (for example, [Search-control] or [Vendors/Portal]). You can also apply functions to generate dynamic values or to transform control and column values as needed.

Open a different workbook

Create an action that navigates to a different Sigma workbook. Open the destination workbook in its published state, or pass specific values to existing control elements to instantly open a drilled-down view.

1. Open a workbook in Explore or Edit mode.

2. Select the element you want to trigger the action, then click Actions in the side navigation.

3. In the Actions panel, click Add action within an existing sequence, or click Add action sequence to start a new sequence.

4. In the Action modal, configure the required fields to define the response:

   Action	Select Open Sigma doc.
   Destination	Select a destination workbook to open. Interacting users can only view the destination workbook if granted permission to access it.
   Pass control values	See Pass values to controls in the destination workbook in this document.
   Open in	Select an option to determine how the link opens in the browser. New window: Opens the link in a new browser window. Same window: Opens the link in the current browser window when the user interacts with the trigger element directly in Sigma. Parent window: Opens the link in the current browser window when the user interacts with the trigger element in an embed. The interacting user’s browser settings may change the selected Open in behavior. For example, New window may instead open the URL in a new tab (same window), and Same window may instead open the URL in the same tab.

5. If your trigger element is a table, pivot table, or input table, select a column in the When selecting cells in field. The action sequence triggers only when the user selects cells in that column.

6. [optional] If you want the action sequence to execute only in certain circumstances, click More, then click Add condition. See Make an action conditional for more information about action conditions.

Pass values to controls in the destination workbook

To open a drilled-down view of the destination workbook, add control targets and rules to the Pass control values field in step 4 of the previous section.

1. In the Pass control values section, click Add a control target.

2. Configure the required fields to identify the control target and define the rule:

   Update control	Select a control element to update in the destination workbook.
   Set value as	Select an option to determine the type of value Sigma passes to the control, then define the value. Specific values: Passes the specified (fixed) value. Values from a column: Passes values from the specified column in the trigger element’s underlying data (if applicable). Only available when the trigger element is a table, pivot table, input table, or visualization. Custom formula: Passes a value based on the defined formula.

3. [optional] Repeat steps 1 and 2 to configure additional control targets and rules.

Navigate the current workbook

Create an action that navigates to a specific location within the current workbook. Shift the focus to the top of a page or to an individual element.

1. Open a workbook in Explore or Edit mode.

2. Select the element you want to trigger the action, then click Actions in the side navigation.

3. In the Actions panel, click Add action within an existing sequence, or click Add action sequence to start a new sequence.

4. In the Action modal, configure the required fields to define the response:

   Action	Select Navigate in this workbook.
   Destination	Select the page or element to focus on in the workbook view

5. If your trigger element is a table, pivot table, or input table, select a column in the When selecting cells in field. The action sequence triggers only when the user selects cells in that column.

6. [optional] If you want the action sequence to execute only in certain circumstances, click More, then click Add condition. See Make an action conditional for more information about action conditions.

Open or close a modal

🚩

This documentation describes a public beta feature and is under construction. This documentation should not be considered part of our published documentation until this notice, and the corresponding Beta flag on the feature in the Sigma service, are removed. As with any beta feature, the feature discussed below is subject to quick, iterative changes. The latest experience in the Sigma service might differ from the contents of this document.

Beta features are subject to the Beta features disclaimer.

Create an action that opens a modal within the current workbook. For more details about modals, see Add a modal to a workbook.

1. Open a workbook in Edit mode.

2. Select the element you want to trigger the action, then click Actions in the side navigation.

3. In the Actions panel, click Add action within an existing sequence, or click Add action sequence to start a new sequence.

4. In the Action modal, configure the required fields to define the response:

   Action	Select Open modal.
   Select modal	Select the modal to open, or choose New modal.

5. If your trigger element is a table, pivot table, or input table, select a column in the When selecting cells in field. The action sequence triggers only when the user selects cells in that column.

6. [optional] If you want the action sequence to execute only in certain circumstances, click More, then click Add condition. See Make an action conditional for more information about action conditions.

To close a modal with an action, repeat these steps and choose Close modal as the action. The close modal action does not have a target. The trigger element must be placed on a modal for this action to function as expected.