The ZIP function combines multiple columns into a table-like structure where each row contains an element from each given column. This is a client-side function only and can be combined with the QUERY function where the output of the ZIP function is given to the QUERY function as an input table.
The ZIP function can be used to reference columns within a repeating section to create a table for use elsewhere. Here is an example of how to do this by creating a repeating section that is used to define a list of options for use in a Choice component:
-
Create a repeating subsection.
-
Add a text type cell within the subsection and give the cell a Cell ID (variable). In our example, the field ID is OptionText.
-
Preview the IndustraForm or open the IndustraForm on j5. Enter choice options into the repeating subsection by clicking the + icon.
-
In a separate subsection, create a choice type cell. Set its Options Source to Import Formula, and use the ZIP function to import the OptionText cells as a list of options.
This will produce a form where the options available in the choice dropdown are populated from the repeated OptionText cells.
The ZIP function can then be combined with the QUERY function to add logic. For example:
-
Add a checkbox type cell next to OptionText called IncludeInOptions.
-
Limit the options for the choice cell such that the options displayed are only the selected IncludeInOptions fields by using the QUERY and ZIP functions.
The output is as follows:
The Choice Options section can be hidden by setting the visibility to false.
