Define input columns

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.

Learn how to:

• Show hidden input columns
• Define new input columns
• Edit the input column settings
• Delete input columns from a worksheet

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.

3. Toggle Show on columns that you want to make visible in the worksheet.
4. 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.

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.