Integrating lookup table to form builder

Developers
1

hi all, I am creating an application where I want users to select a source of input information (dropdown from mobile App) from a lookup table. I am getting a challenge in this.

2

Hello Mary,

Thanks for reaching out.

In order to select options from a lookup table, you can use a multiple choice or checkbox question type in your application. For more information, visit our documentation here.

Additionally, you can follow this guideline to achieve this:

  1. Setup the Lookup table - First, ensure that your lookup table is correctly set up in CommCareHQ. You can upload your data in an Excel file format, ensuring that the columns are correctly defined for the data you want to display.
  2. Add a multiple choice question in your form - In your form, add a multiple choice or checkbox question. This will be used to display the dropdown options.
  3. Link the Lookup table - Go to "Lookup Table Data" in the form builder and select the correct lookup table. Choose the value field (which will be stored) and the label field (which will be displayed to the user).

Best,
Shahid

3

Very grateful Shahid. I solved the issue of lookup table.