Run specific query based on dropdown

Queries and Resources
1

Hi,

I am trying to run 1 of 5 queries based on a specific dropdown value. I am still relatively new to Retool, so I am not entirely certain on the options, so any advice is greatly appreciated!

2

If you post some screenshots it will help me understand the context. Basically, you can pass the value of the select field into the query using {{select field.value}}

3

Hi,

Essentially it is a dropdown with three companies (1, 2, or 3) and I need an ID in the SQL to change based on what that company is (and an associated ID).

4

If you send some screenshots I will try to send you a solution using your variables