Pulling data into drowdown within a table via data connector

Julie Gavin

January 24, 2022 16:39

Hi,

I cannot seem to figure out how to pull data via a database connection into a dropdown that is housed within a table. The URL contains a parameter as well.  I was able to use a business rule to pull the data into a dropdown positioned on the form (not in a table) but the same rule does not work if I move the field within a table. Also, I was unable to get the dropdown to work via the general dropdown settings, but it possibly has to do with how my URL is formatted since a parameter is needed.

0

• Official comment

  

  Megan Ellis

  January 24, 2022 21:52

  A Table control is essentially a repeat, so you will need to update the rule to loop through the table and set the options for the dropdown on each row of the table. There is an example of this type of rule here in our Database Connector Tutorial (the "Products" example.) See these examples for working with rules for tables. 

  Also, frevvo provides a built-in no-code Dynamic Options feature in the form/workflow designer. See this documentation and short video to see how it works. 
• 

  Julie Gavin

  January 25, 2022 14:07

  Thank you for the reply. Is there an example of the no-code Dynamic Option where a parameter from the form is in the URL (such as person ID)?

  0
• 

  Megan Ellis

  January 26, 2022 21:22

  Yes, you can add the control template in curly braces to your Options URL as shown in this example.

  0

Please sign in to leave a comment.