2-way filter for choicefilter using pull or any other functionality

Hi

I want to implement a two way for the below scenarioa

I have 6 fields lets Say

  • Common Name
    -Scientific Name
  • Genus
  • IUCN status
  • Family Name

So , The 2 way filter should work for common name and scientific name as data collection user may know either scientific name or common name ,So,
-If he filter commoname then other 4 fields should be filled automatically (Scientific name, Genus, Family , IUCN)
Similarly when scientific name is chosen then other rest 4 fields should be field like (Common name, Genus, family and IUCN).

Common name and scientific name should be as two way filter

Any suggestion and template in xls form please

Thank You

Welcome @Abnan,

Do you use Enketo (webform) or Collect? The latter allows to set fields read-only dynamically, which could be an advantage in your scenario.

I didn’t use it before

Is there samplE example

Using xls form

I shall be thankful to u

Why not use one (combined) select, showing common name - scientific name together in each choice label? And then fill automatically the following fields. The filling could be done based on additional column in the choice list.

not possible brother

Because common name is linked with scientific name

Both should be separate field with 2 way

any example with an xls I’m a new person to start with it and I shall be thankful

If anyone can share an example with xls