Error in input tool while running the app

[Priyam]

I have created a simple app. Basically, it inputs 4 excel files and outputs them into SQL tables. It works fine when I select all the 4 inputs. I am trying to add another feature which is that even if I select 1 file then it should run without giving any error. Can you suggest how it can be done?

Currently it throws an error like : 

• The Action "Tool #4" has an error: The file name is empty.

[StephenR · Accepted solution]

You can nest the File Browses under Check Boxes and set the check box to Collapse Group when Deselected.  This will turn off the input.

[MarqueeCrew · Accepted solution]

@Priyam,

Try this:  Put your logic for the input file into a container.  Use an action to update the ENABLE/DISABLE button with:  IIF(isempty([#1]),'True','False').

If someone doesn't give you an input file, you can disable the container.

Cheers,

Mark

[Priyam]

Hi Mark,

Thanks for your prompt reply. I was able to implement the solution.

Best,

Priyam

[Priyam]

Thank you very much for your prompt reply. I was able to implement the solution to this.

Best,

Priyam

[mmenth]

One additional thing I noticed when trying to get this to work-- The files that are being shut off by the disabled tool container must have the required box unchecked (see screenshot) in the configuration. I was getting an error until I toggled this!

[av46]

Hi Stephen,

I am still getting the error file is empty. This is how I have nested the boxes. Could you let me know what I am doing wrong? Thanks Anita

[maazinh]

Thanks for this! Was what I needed to do for it to work