Is there anyway we can get English version of the option as output even if the options are displayed in other language. Problem: I want to add instance name for the dynamic file name and for that I need state names. Now, there are three languages involved here (english, spanish, italian). Now though the interviewer is using the form in spanish, I wanted to fetch the english options of that and not spanish. Is there any way to achieve this ?? PS: Hope my question was clear.
Awesome! Do you know if we can use a similar method when connecting PowerBI to Kobo API ? I've noticed the labels are left behind. And only the xml names are brought in to PowerBI.
If you calculate the label using jr:choice-name, then there will be a column that shows up in Power BI with the 'label' instead of the 'name' / XML value, yes.
Hello, thank you for this video. I would like to know how to retrieve the labels of a "select_multiple" type question to display them in the choice options of a "select_one" type question. Example : if I have a multiple choice list in Q1 type "select_multiple": Q1 What fruits do you like? - orange - mango - lemon - tangerine The user chosen: mango, orange. How to display your choices in the Q2 question type “select_one”: Q2 What is your favorite fruit? (I want to be able to display in question Q2 of type "select_one" the chosen fruits [mango; orange]). Thank you.
Hi! The functionality you're looking for is called "choice filter"... Watch this video to learn how: ruclips.net/video/frQMW_GNRdg/видео.htmlsi=i8L49QGm4d0J3oOR
![Link ODK Collect Directly to Google Sheets in Google Drive [NO LONGER SUPPORTED]](/img/1.gif)
Thank you Janna, I've always struggled with the underscores....finally the solution has arrived!!!
YES Anthony!! Beautiful solution, isn't it?!
I like the music in the background. Thank you for this clear explanation Jana ❤
Oh thank you! So glad it was clear! Hope it helped 👍
It helps, and clarify a lot of gaps in my site. Thank you so much.
Thank you for this insightful video, Janna!
Glad it helps!!
Is there anyway we can get English version of the option as output even if the options are displayed in other language.
Problem: I want to add instance name for the dynamic file name and for that I need state names. Now, there are three languages involved here (english, spanish, italian). Now though the interviewer is using the form in spanish, I wanted to fetch the english options of that and not spanish. Is there any way to achieve this ??
PS: Hope my question was clear.
Awesome!
Do you know if we can use a similar method when connecting PowerBI to Kobo API ?
I've noticed the labels are left behind. And only the xml names are brought in to PowerBI.
If you calculate the label using jr:choice-name, then there will be a column that shows up in Power BI with the 'label' instead of the 'name' / XML value, yes.
I need asolution for this problem
Hello,
thank you for this video.
I would like to know how to retrieve the labels of a "select_multiple" type question to display them in the choice options of a "select_one" type question.
Example :
if I have a multiple choice list in Q1 type "select_multiple": Q1 What fruits do you like? - orange - mango - lemon - tangerine
The user chosen: mango, orange.
How to display your choices in the Q2 question type “select_one”: Q2 What is your favorite fruit? (I want to be able to display in question Q2 of type "select_one" the chosen fruits [mango; orange]).
Thank you.
Hi! The functionality you're looking for is called "choice filter"... Watch this video to learn how: ruclips.net/video/frQMW_GNRdg/видео.htmlsi=i8L49QGm4d0J3oOR
@@HumanitarianDataSolutions Hello! Thank you very much.
thanks
Very welcome!
can i use it with (multi select) question ?
Yes you can! You need to use the 'selected-at' function. What's your use-case?
@@HumanitarianDataSolutions thanks