Edit SQL Query in Input Data Tool

[Dylan_Brown]

I have created a workflow using one input that queries our database.  In that query, I can specify which vendor I want to pull sales for.

What I am trying to do is create an app where I can run the flow for any vendor without having to go in and change the input manually.  I have tried using dynamic input but can't figure out how to change the query.  With the dynamic input, I am not sure what tool to connect to it's input either.

Any help is appreciated!

[LordNeilLord · Accepted solution]

Hey @Dylan_Brown

Presuming your SQL looks something like this:

You can then use a text box and action tool using the "replace specific string" option like this:

[Dylan_Brown]

I played around with it some more yesterday and figured it out.  This totally works!

Thanks!

[kwilkins]

Hello there. Does your solution also work when replacing a date? I've used the "Date" and action tools, without success.