I'm developing a workflow to help with our accounting consolidation process each month, taking in about 15 separate Excel workbooks (each representing a separate subsidiary entity at our business), transforming the data through a separate container process for each, and outputting to a common Excel file.
The problem I'm trying to solve for is that we don't receive all 15 workbooks for input on the same day, but I'd like to save time by running the workflow as we receive each one. To do this, I've set up Check Box and Action tools to enable/disable each container. What I still need is for the analytic app to ignore downstream Interface tools for the containers that aren't selected and show only the Drop Downs or List Boxes for the containers that correspond to the workbook(s) that our team has received at that time.
I know also that Interface tools cannot run inside disable containers, so it sounds like any downstream Interface tools will need to be outside each container. Any tips on how to nest those tools under their corresponding Check Boxes? Thanks!
