Use entity list in multiple select with filter

Support
1

Hi all,

I have a large list of tree species on organisation level. I would like to use an entity list to store these tree species/organisation and perform a multiple_select (or select_one) on those species. The entity list contains the following fields:

  1. latin_name
  2. local_name
  3. organisation_name
  4. label (mandatory)

I want to show the latin names in my multiple_select, using a filter on organisation_name. At present, my multiple_select shows the label field values. As the label field has to be unique I had to use CONCAT to create labels that is combined 'latin_name + local_name+organisation_name' to make them unique. However, I don't want to show my labels in my multiple_select, but only the field with latin_name. How can I do this?

Do I need to:

  1. Call the instance of the entity to get the latin_name field?
  2. Change the label in the merge API (source_label_key='label')?

Any help is appreciated. Thanks!

2

Hi all,

Found the solution already. It is explained here: https://docs.getodk.org/form-datasets/#referencing-values-in-datasets. SO you have to change the parameter settings and use it in combination with select_multiple_from_file

1 Like