Support Center

Bind or update a single form field via SQL Query

Allows you to bind or update a field by executing a SQL Query; optionally based on another field.

For example:

You have a table Cars with column Year

  1. Select Field Name as Year and execute the following SQL Query "Select distinct Year from Cars ORDER BY Year DESC"
     

    Categories

  2. Add a dropdown field to your form."
     

    Categories

  3. This binds the row values with form dropdown in descending order.
     

    Categories

Glad we could be helpful. Thanks for the feedback.

Sorry we couldn't be helpful. Your feedback will help us improve this article.

How helpful was this page?

  
Updated on Thu, 31 Jan 2019 by Ashish Pachori