Populating an option list from an external source (e.g. CSV file) is very useful for long option lists (e.g. countries) or dynamic option lists that changes over time. This article explains how to populate select options for select (one/many) fields and cascade fields.
Select one/many fields
Open the Option list tab of your select field and navigate to "Get options from a source file".
- Once you have uploaded the CSV file containing your options into your project's resource library, select it from the 'Source file' drop-down.
- Choose the source column for the option label (text).
- Choose the source column for the option value.
- You can download a template CSV file to populate and upload to your project resource library.
By default, options will be listed vertically. For long option lists you can select "Searchable option list" from the Advanced settings tab. Configuring the display of option lists is covered in our article on appearance settings.
If you are subscribed to the standard plan or above, it's possible to filter the option list available to a data collector based on static values, other fields in the form, or columns in the CSV file. Detailed steps and examples for filtering option lists are covered here.
Similar to select one/many fields, options can be populated from an external source like a CSV for example.
If your form has been translated into multiple languages, you can add columns in your CSV file for each translation. Simply specify the column to use for the text. This will need to be specified for each language that the form has been translated in. Values are used as field identifiers for data analysis and will remain the same across all languages.
Additional validation rules are applied to both the header and data rows of a CSV file resource to ensure issues do not occur during data collection.
Note: Steps to upload resources (e.g CSV files) to your resource library is covered in detail here.