[FORM] Create request to display run values into Dropdown

I'd like to create a form with a dropdown question with option displayed based on a query

Hi @Theo_Souverain, and welcome to the forums.

I think these two posts will be good to start with

If you still need help, do send screenshots of your forms and queries

1 Like

Hi @MiguelOrtiz, I use de Form type of Retool App (not an embedded form)

Hi @Theo_Souverain!

While you can't write a custom query, you can use resources to dynamically set values in a select. Please see below!

Thanks Abbey, the use case is :

My first question create a filter for the second question.

Ex :

  1. What's your company sector ?
    Real estate

  2. What's your role ?
    (Here a SQL query gives all the roles available in real estate by filtering a role.table on the "Sector" field)

  • Real estate agent
  • Property manager
  1. List item
1 Like

Thanks @Theo_Souverain,

I'll log this feedback for our eng team!