Help center
Sign inTry for free
Course contents11 lessons
Course overview
  1. Headers
  2. Responsive
  3. Pagination
  4. Copy and Paste
  5. Text Masks
  6. Formatting – Metadata
  7. 07Hide Columns
  8. 08Hide/Disable Rows
  9. 09Column Widths
  10. 10Form-based Input Grids
  11. 11Grid Alignment

Lesson 7 of 11

Hide Columns

You can set the visibility of individual columns in an input grid by selecting that column in the grid options in the user interface designer, and selecting…

1 min read

You can set the visibility of individual columns in an input grid by selecting that column in the grid options in the user interface designer, and selecting an option from the Visible in the Grid property.

Always and Never options can be used to permanently show or hide the column. If your workbook contains any Boolean named ranges, you will be able to select a third option named By Value Of. When this option is selected, the column visibility will toggle depending on the selected named range.

The Boolean named range will be calculated each time when the calculations are triggered in the runtime. If this field returns TRUE, the column will be visible. If it returns FALSE, the column will be made hidden. This way, you can show or hide columns dynamically during runtime.