Auto update choices in select one question

User Support Form Building
, , ,
1

Hi!

I want to create a form with select one question and the available answers to be automatically renewed,
Maybe by connecting the form with an excel where the options/answers are saved.

Thank you in advance for your consideration!
Katerina

2

If you have limited response options, you could do this as outlined in the support article Including Responses Inside Another Question. But if you wish to add unlimited choices, maybe it would be impossible.

3

Hi @helios_me, you can try using a select_one_from_file question and regularly updating the choices file. There’s also the upcoming basic case management feature being released soon that may solve this:

1 Like
4

Thank you Kal Alm for your reply.
Unfortunately this would not work for me as the choices are not answers from another question.
I am trying to build an attendance sheet. Students are removed/added during the course lifespan so I want to be able to retrieve the students names-answer options from the students’ list file.

5

Thank you Josh! Very useful file in overall
As I am not familiar with csv and xml file is that the same with uploading xls file for building a form?

Looking forward for the new feature, how will we be informed about its availability?

Many thanks!

1 Like
7

@helios_me, you could follow the same through our announcement. The announcement will be made in the community.

8

Hi @helios_me, that’s great! You can refer to the support page here on media uploads, however the management of media has changed slightly and the support page still needs to be updated to reflect this. You can refer to the discussion here regarding the changes:

1 Like
9

I realise this is an old thread, but I had a similar question, and this one has popped up a few times from various people I’ve talked to, so wanted to press into it a bit.

If I have a select_one_from_file question, I want to figure out a way to auto-update a csv file from text answers being submitted from a form. That ‘list’ of text answers is what I want to show up in my select_one_from_file choices. Is there a way to automatically replace the media file for the KoboToolbox project, and then re-deploy the project automatically? Say, if I wanted to update it each night at midnight automatically?

Thanks for your thoughts!

1 Like
10

hi janna…
i have sent you a comment on youtube
i need the same thing yes
but i need to immediately got update after each individual submission
note:
i have seen a form do the same thing but just the form and i dont know how it make like this

11

here u said if i wanted to update it each night at midnight automatically
but i want to update it immediately after each individual submission
i have seen like this form here in Syria
but i dont know how it is done and how the person how make that form could do this idea
so please, it is possible to make it because someone else has implemented the same idea

this is my scenario i want to make select_one_from_file that its choices are the name of beneficiaries that are submitted from the same form suppose text question
so when i make this question (select one from file) autocomplete i dont need to rewrite the name again
i hope i could illustration this scenario well