Prompt user to choose all files, latest file or only specific set of files analytical apps

[Sumaya52]

Hello everyone,

I want to create an analytical app that prompts the user to read all files in the chosen directory or only the latest file (based on year on the file name) or allows the user to choose specific files by showing all files using check list tool. And then I want to send the final result to a macro.

Any one has an idea on how to do that?

[FinnCharlton]

Hi @Sumaya52 , here is the framework for the interface part of this challenge. All it should need is a dynamic input to import the files. In short, we use radio buttons to allow the user the choose the option they want. The choice of radio button determines how we filter the results of the directory tool. We can allow the user to select files with the list box tool. Hope this helps!

[AdamR_AYX]

I went with a chained app approach to allow the user to be able to choose specific files

[Hanspeter]

@FinnCharlton : I like your approach. Unfortunately, the directory tool does not automatically update when running as an analytic app when files are added or removed to the folder (option "select file"). Any idea how to make it update the files to select from?

( @Sumaya52 or @AdamR_AYX )