Expand/collapse collections based on the data

DesiPilla

Is there a way to dynamically expand/collapse a container based on specified criteria in an Interactive app? Two examples of what I mean:

1. The output tool is placed inside a container. At the end of the workflow, if the data row count = 0 then collapse the container with the output tool and do not write any data. If the row count > 0, expand the container.
2. An input file is loaded. If Column A is present in the file, expand a container that takes the data and manipulates/preprocesses/augments/etc the data. If Column A is not present in the file, collapse this container and expand a different container with some other process.

Essentially, I want to create some sort of logic that passes data to different flows based on information that is learned at runtime. I'm only aware of a way to expand/collapse containers based on user inputs in the app GUI, which will not work for this. 

Thanks,

mceleavey

Hi @DesiPilla ,

Yes, this is fine although I think you mean enable/disable the container rather than expand and collapse as that will have no functionality at all.

The best way to do this is to put the containers into a macro, add a control parameter and connect it to the disable/enable button. You can then feed the value that will determine this function into the macro as the batch parameter value.

For example, you can count the records and feed the record count into the macro as the control parameter value. In the macro, set the action to be update via a formula, and tell it be disable = "false" where the [#1] value is >0.

If you post your workflow I can build that for you if it's not clear.

M.