Dynamic Select Tool from Input File

JordyMicheal

Building an analytic app and needed a little help:

There is the workflow currently (also attached). It let's the user select a company from the list and then select the fields they want in the report.

I want to feed this an input into the list box (some customers want different fields) and based on that input file, select the fields.
Just a little more dynamic and a little less interaction
My idea is the input file would look like this but open to any ideas also:

                       Field 1      Field 2      Field 3   Field 4
Company A       0                1                  1          1
Company B        1                 0                 1           1

So my desired output, would be losing the 2nd select I have in the interface, just selecting a company and having the output.
So Company A would be Field 2, 3, and 4 while Company B would output Field 1, 3, and 4.

DynamicSelects.yxmd

MichaelSu

Hi @JordyMicheal ,

Please see attached files. The approach I took in this case was to leverage chained apps. This will allow the user to select the initial company names and then after they are selected, the appropriate columns (capital, total, cars, trucks) will then populate with only those values >0

In order to chain, be sure to open up the interface designer.

Thanks,

Mike

App1.yxzp

App2.yxzp