Hello!
I am experimenting with lookup tables to place adm1-adm4 hierarchy of toponyms in them. That is, after choosing a region, the next question contains only districts of this region, etc. But I get the error TypeError: t.getNodeFromItem(…) is null
I’ll attach the form ASAP (as a new user it’s impossible for now)
The survey url: Enketo Express for KoboToolbox
Thanks in advance for your help
Welcome to the community, @AL_meal! Are you using the select_one_from_file
type question?
Thank you! Yes, it’s correct:
adm_lookup.csv
adm1,adm2
UA01,UA0102
UA01,UA0104
UA01,UA0106
UA01,UA0118
UA01,UA0110
…
survey
sheet:
type |
name |
label |
required |
appearance |
relevant |
choice_filter |
select_one_from_file adm_lookup.csv |
adm1 |
Select ADM1 |
yes |
|
|
|
select_one_from_file adm_lookup.csv |
adm2 |
Select ADM2 |
yes |
|
|
adm1=${adm1} |
settings
sheet:
setting |
value |
form_title |
ADM Selection |
instance_name |
${adm1}-${adm2} |
choices
sheet:
list_name |
name |
label |
adm1 |
UA01 |
Автономна Республіка Крим |
adm1 |
UA71 |
Черкаська |
adm1 |
UA74 |
Чернігівська |
adm1 |
UA73 |
Чернівецька |
… |
|
|
*Still can not attach files
Hi, I tried to create a form as similar as i can to give you the general idea how Select_one_from_the_file work. You can check the survey below to test. I am also sharing the form and csv file.
https://ee-eu.kobotoolbox.org/x/y2okO7pZ
adress.csv (4.0 KB)
aEANmmyFqiZVbXxRxPhkV7.xlsx (11.0 KB)
1 Like
@osmanburcu I don’t understand the logic of the form yet, but I really appreciate your help. It works exactly as expected
Here these two questions (adm1, adm2) are repeated twice, because they are 2 different solutions?
Hi, Yes, there is two method there one is directly encoded into form it is useful if you have a short list of options. Second is more useful if your list include more than 100-200 options.