If you need to import many options into a Select field, adding each option one at a time in the designer can be slow.

There are 4 methods to populate larger lists of options:

Select Options from a Resource

Click here for more information on how to set this up.

Import Options from File

When viewing your select question options in the designer, you'll have the ability to import your options from a file.

  1. Create Your Data Spreadsheet

Set up your data in a spreadsheet and save it in a CSV file format or an Excel file (.xlsx).

When using a .csv file, your options will need to be in the first column. (Text first, then an optional Identifier, separated by a comma).

If you are using an Excel file, your spreadsheet will need to looks as follows. The Identifiers in Column B are optional. 

2. Import Your Data Spreadsheet

Under the Select Question, select Fixed Options, and click the Edit options link.

Then click "Import Options from File",

Click "Upload" and navigate to the file in your directory. After selecting your file, click "Import". 

You will then see the new options have populated in your select question.

Bulk Upload

You can Bulk Upload your options from a spreadsheet, as well!

Locate your form in your "Forms" list and click the gear button to the far right. Then select 'Bulk Upload.'

On the next screen, first choose your select question.

Then click "Choose File" to open your directory. Navigate to your .csv file and select it.

When you are done, click "Upload options to select".

Note: Only CSV files are supported for this method of bulk uploading.

Once the file has finished uploading, refresh your forms list on your mobile device and the updated options will appear in your mobile form.

Editing the JSON File

Another way is to manually edit your form's JSON file.

First, export the JSON file and open it in a basic text editor, such as Wordpad, Notepad, etc.

Copy the select question option from the JSON file, making sure to include the comma at the end of the last option, and paste below to add more options.

Edit the names of your new options, and save the file:

Import the JSON to replace your current form.

You will then see the new options have populated in your select question.

Other Useful Articles:

If you have any questions or comments feel free to send us a message at support@devicemagic.com.

Did this answer your question?