Use multiple variables in Filter Tool which are obtained via Interface Tools

[thv]

I have a Filter Tool which contains the following custom filter statement:

• [Acct. Type]="BS Accounts" and
• [COA]="selectedCOA" and
• [Entity]="selectedCC"

I would like to dynamically obtain from the user during the app execution the values for selectedCOA and selectedCC and filter [COA] and [Entity] accordingly.

I have created an Action Tool which will -using the function "replace a specific string" -  replace the value of "selectedCC" and "selectedCOA" with a value a user has selected in Drop Down Tool.

My questions:

- My Filter Tool only accepts 1 Action Tool to be connected. Does this mean I have to split [COA] and [Entity] into 2 Filter Tools?

- Is there actually a better way to achieve what I want to achieve?

Many thanks,

Thomas

[binu_acs · Accepted solution]

@thv Filter tool can accept any number of action tool inputs.

[thv]

Many thanks for the clarification, binuacs!