Data export missing in database

User Support Form Building
,
1

Good evening to all,

Please, how to set a default value for a conditional question in KoboToolbox, so that the question can have a predefined answer in the database even if it is not displayed?

For example, if the first question is “Do you have experience?” with two possible options (yes or no) and the second question is “How many years?”, which is only displayed if the answer to the first question is “yes”, how do you set a default value for the second question when the answer to the first question is “no” and the second question is not displayed, so that each record has a value for the “how many_years” variable in the database?

Thank you.

2

Design hint: Why not use one question: How many years do you have experience? 0 as answer option included.

1 Like
3

Thank you for your feedback.
But is there a more direct solution?

4

You can use a calculation field in the Survey sheet which one will be used as the final input of year_of_experience in the database.

In the survey sheet of your xlsxform :

image
image1252×123 6.39 KB

Exported file would be :
image

1 Like