Define input columns
  • 03 May 2024
  • 3 Minutes to read
  • Dark
    Light

Define input columns

  • Dark
    Light

Article summary

All IQ Interface worksheets contain input columns. You can recognize input columns in a worksheet by the absence of a yellow- or green-colored bar under the column header.

Columns.png

Learn how to:

Show hidden input columns

At least one input column is added during worksheet creation. There may be more columns in the underlying data source that you can make visible and available for use.

  1. In a worksheet, select Column and KPI Settings.
  2. In the Column tab, select Manage Columns, then select Show Hidden Columns.
Tip

The color of hidden columns is faded​ to distinguish them from visible columns.

  1. Toggle Show on columns that you want to make visible in the worksheet.
  2. Hide the Column and KPI Settings panel, then drag the new column's header label to the position you want in the worksheet.

Define new input columns

You can define entirely new input columns that don't yet exist in a worksheet's primary data source. In this case, a corresponding column is automatically added to the primary data source, and is populated with data that you add to the worksheet.

Important

When defining a new input column, specify the input behavior for that column. For example, you can configure a column to accept any manually-entered input value that is supported by the column's data type, or constrain the possible input values to a limited set of dropdown list or type-ahead list choices. For more information, read Configure dropdown fields and Configure type-ahead fields.

  1. In a worksheet, select Column and KPI Settings.

  2. On the Column tab, select Manage Columns, then select New Input Column.

  3. In Column Settings, on the General tab, enter or select values for the new column:

    • Column Name—Enter a user-meaningful label for the column.
    • Display—Select a column display value. Valid values are Integer, Float, Currency, Percentage, and Number.
    • Type—Define the input behavior for values in this column.
    • Pinned—Select whether to pin the column so that it always remains visible in the browser window.
    • Required—Select to make the new column required when building a new row in a worksheet.
    • Editable—Selected by default. Uncheck this option to make it read-only.
    • Visible—Selected by default. Uncheck this option to hide this column in the worksheet.
    • Include Default—When selected a Default Type dropdown appears. You can specify a Field you want to get your default values from. Alternatively, you can select a Value, and then type a desired value for that default type in the Default Value field.
  4. In Column Settings, on the Column Highlighting tab, optionally configure column highlighting.

  5. Select Save.

  6. Hide the Column and KPI Settings panel, then drag the new column to the position you want in the worksheet.

Edit the input column settings

  1. In a worksheet, select Column and KPI Settings.
  2. On the Column tab, select the column that you want to edit.
  3. Make changes in Column settings, then select Save.

Delete input columns from a worksheet

There are two different ways to remove input columns from a worksheet.

Hide a column but keep it in the worksheet

  1. Select Column and KPI Settings.
  2. On the Column tab, toggle the eye-shaped icon on the column name.

Permanently delete a column from the worksheet

  1. Select Column and KPI Settings.
  2. On the Column tab​, select the column you want to delete.
  3. In Column settings, select Delete.
Note

Selecting Delete does not remove the column from the underlying data source. It only deletes the column from this worksheet. Other worksheets might be using the same column data from the same data source.


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.