Filter via user inputs from text box

[nkjy]

Hello, I am trying to filter the currency rate based on inputs from user (eg. JPY) however I am struggling to configure the action tool to have the variable inside the formula in my filter tool. Any kind soul able to help out here please.

[jzkyburz]

You were really close! You just needed to put quotes around your variable in the filter: 

'[#1]'

[Kakuffo · Accepted solution]

hi @nkjy  if you replace the #1 with "[#1]" and then have the action tool replace "[#1]" it should work for you ive attached my version, which i used a currency abbreviation in place of the [#1]