Edit SQL Query in Input Data Tool

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!

Developer Tools

Tips and Tricks

Accepted answers

Hey @Dylan_Brown

Presuming your SQL looks something like this:

Input 2.PNG

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

All comments

Hey @Dylan_Brown

Presuming your SQL looks something like this:

Input 2.PNG

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

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

Thanks!

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703