How to pull Data Table values into your Form

How to pull Data Table values into your Form



Automatically populate data table values into form fields

You can incorporate values from data tables directly into your form using array controls (Lists, Grids, Tables, etc.).  

To start, add an array control to your form. The most commonly used field type for this use case is a List. 



Referencing your data table in the Admin Tool, for each column in the data table (not including the Record Key) drag a field of the same type into the List. 

In this example, we’re using a data table that pulls in state information and will reference the following schema: 


The list now looks like this with 3 string fields and one integer field. 


Name each field on your form the same as the schema name, keeping in mind that the names are case sensitive. 

Set an initial calculation of “reference table” for the list, select your reference table and configure any additional information like “sort by”



Preview your form and see all the values from the data table pulling into the list on your form