Edit Input Table Data

When you edit input table data (i.e., add rows or edit table values), the workflow depends on the individual element’s data entry permission.

The default permission allows you to edit input table data in the workbook’s draft version (Edit mode) only. However, authorized users can change the data entry permission and instead restrict editing to the published version (View and Explore mode).

This document explains how to edit input table data based on the element’s data entry permission. For more information about input tables, see Intro to Input Tables and Create and Manage Input Tables.


Contents

System and User Requirements

Identify Editable Input Tables

Draft Version (Edit mode)

Published Version (View and Explore mode)

Edit Data in Draft Version

Edit Data in Published Version

Related Resources


System and User Requirements

The ability to edit input table data requires the following:

  • Draft version (Edit mode)
    • You must be assigned an account type with the Edit Workbook permission enabled.
    • You must be the workbook owner or be granted Can edit workbook permission.
  • Published version (View or Explore mode)
    • You must be assigned an account type with the Explore Workbook permission enabled.
    • You must be the workbook owner or be granted Can explore or Can edit workbook permission.

Identify Editable Input Tables

Because data entry permission is configured at the individual input table level, a workbook may contain some input tables that allow you to edit data in the draft version and others that allow you to edit data in the published version.

When the data entry permission restricts editing to the published version, Sigma displays an indicator in the element to signal the change from the default behavior. The indicator can help you differentiate between input table data you can and cannot edit.

Draft Version (Edit mode)

In Edit mode, the input table displays a Data Entry tag to indicate that you cannot edit the data in the workbook’s draft version. To edit the input table data, you must open the published version in View or Explore mode. Alternatively, if you’re granted Can edit workbook permission, you can change the input table’s data entry permission.

The data entry permission only impacts data editing. All other input table functionality (column management, data validation, column protection, etc.) remains limited to the workbook’s draft version.

Draft Version
Can edit data Cannot edit data

Published Version (View and Explore mode)

In View and Explore mode, Sigma displays an Edit Data button to indicate that you can edit the input table data in the workbook’s published version. For more information, see Edit Data in Published Version.

Published Version
Can edit data Cannot edit data

Edit Data in Draft Version

  1. Open a workbook in Edit mode and locate the input table you want to edit.

    If the element displays a Data Entry tag, you must edit the data in the published version.

  2. [optional] To add a row to the bottom of the input table, click the last row.

    You can only add rows to empty input tables. Linked input table rows and row count are defined by the primary key column.

  3. Edit input table values:
    • To enter data through keyboard entry, select a cell and enter a value.
    • To paste values copied from Sigma or an external source (e.g., a spreadsheet, text document, etc.), select a cell or range of cells, then right-click the selection and select Paste.

      You can select and paste values in up to 12,500 cells at once, including column headers.

    • To select a predefined value, click the caret () in a cell, then select an option in the dropdown.
  4. To save the input table edits to the workbook’s published version, click Publish in the workbook header.

Edit Data in Published Version

  1. Open a workbook in Explore mode and locate the input table you want to edit.
  2. Click Edit Data to enable editing.
  3. [optional] To add a row to the bottom of the input table, click the last row.

    You can only add rows to empty input tables. Linked input table rows and row count are defined by the primary key column.

  4. Edit input table values:
    • To enter data through keyboard entry, select a cell and enter a value.
    • To paste values copied from Sigma or an external source (e.g., a spreadsheet, text document, etc.), select a cell or range of cells, then right-click the selection and select Paste.

      You can select and paste values in up to 12,500 cells at once. This doesn’t include column headers since column naming is limited to the workbook draft version.

    • To select a predefined value, click the caret () in a cell, then select an option in the dropdown.
  5. Sigma displays yellow markers in cells that contain unsaved changes. To manually commit your edits to the workbook’s published version, click Save.

Related Resources


Was this page helpful?
Yes No