# Default Value for Skipped Question

**URL:** <https://forum.getodk.org/t/default-value-for-skipped-question/4939>\
**Category:** Support\
**Created:** [October 31, 2015, 3:23am UTC](https://forum.getodk.org/t/default-value-for-skipped-question/4939 "2015-10-31T03:23:15Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kimchhoypkc](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/k/ee7513/32.png) [@Kimchhoypkc](https://forum.getodk.org/u/Kimchhoypkc)\
**Post date:** [October 31, 2015, 3:23am UTC](https://forum.getodk.org/t/default-value-for-skipped-question/4939/1 "2015-10-31T03:23:15Z")

</div>

Hi!

I do not know if it is possible but I am now trying to find the way to give the default value (numeric) for the skipped questions. Is there any possibility to do it? And if there is, could you please give me the guide with syntax? Your kindly responses are highly appreciated!

Thanks!

---

<div class="post-metadata">

**Author:** ![Louis\_Omoya](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/louis_omoya/32/9574_2.png) [@Louis\_Omoya](https://forum.getodk.org/u/Louis_Omoya)\
**Post date:** [November 1, 2015, 6:54pm UTC](https://forum.getodk.org/t/default-value-for-skipped-question/4939/2 "2015-11-01T18:54:25Z")

</div>

Hi? I have considered how to do what you asked.

1. Delete the other specify columns that are blank when data is exported.  
You don't need such columns  
Hi!

I do not know if it is possible but I am now trying to find the way to give  
the default value (numeric) for the skipped questions. Is there any  
possibility to do it? And if there is, could you please give me the guide  
with syntax? Your kindly responses are highly appreciated!

Thanks!

> **···**
>
> -- -- Post: opendatakit@googlegroups.com Unsubscribe: opendatakit+unsubscribe@googlegroups.com Options: http://groups.google.com/group/opendatakit?hl=en
> 
> * * *
> 
> You received this message because you are subscribed to the Google Groups  
> "ODK Community" group.  
> To unsubscribe from this group and stop receiving emails from it, send an  
> email to [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com).  
> For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![yanokwa](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/yanokwa/32/1695_2.png) [@yanokwa](https://forum.getodk.org/u/yanokwa)\
**Post date:** [November 2, 2015, 3:12am UTC](https://forum.getodk.org/t/default-value-for-skipped-question/4939/3 "2015-11-02T03:12:15Z")

</div>

You can assign defaults when you build the form, but you can't assign them  
dynamically (e.g., on skip). If you explain the high level problem you  
are trying to solve, perhaps we can suggest other approaches.

Yaw

> **···**
>
> -- Need ODK consultants? https://nafundi.com provides form design, server setup, in-field training, and software development for ODK.
> 
> On Mon, Nov 2, 2015 at 1:54 AM, Louis Omoya [louisomoya@gmail.com](mailto:louisomoya@gmail.com) wrote:
> 
> > Hi? I have considered how to do what you asked.
> > 
> > 1. Delete the other specify columns that are blank when data is exported.  
> > You don't need such columns
> > 
> > Hi!
> > 
> > I do not know if it is possible but I am now trying to find the way to give  
> > the default value (numeric) for the skipped questions. Is there any  
> > possibility to do it? And if there is, could you please give me the guide  
> > with syntax? Your kindly responses are highly appreciated!
> > 
> > Thanks!
> > 
> > ## --
> > 
> > Post: [opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com)  
> > Unsubscribe: [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com)  
> > Options: [http://groups.google.com/group/opendatakit?hl=en](http://groups.google.com/group/opendatakit?hl=en)
> > 
> > * * *
> > 
> > You received this message because you are subscribed to the Google Groups  
> > "ODK Community" group.  
> > To unsubscribe from this group and stop receiving emails from it, send an  
> > email to [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > 
> > ## --
> > 
> > Post: [opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com)  
> > Unsubscribe: [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com)  
> > Options: [http://groups.google.com/group/opendatakit?hl=en](http://groups.google.com/group/opendatakit?hl=en)
> > 
> > * * *
> > 
> > You received this message because you are subscribed to the Google Groups  
> > "ODK Community" group.  
> > To unsubscribe from this group and stop receiving emails from it, send an  
> > email to [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![Kimchhoypkc](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/k/ee7513/32.png) [@Kimchhoypkc](https://forum.getodk.org/u/Kimchhoypkc)\
**Post date:** [November 2, 2015, 5:42am UTC](https://forum.getodk.org/t/default-value-for-skipped-question/4939/4 "2015-11-02T05:42:02Z")

</div>

> You can assign defaults when you build the form, but you can't assign them  
> dynamically (e.g., on skip). If you explain the high level problem you  
> are trying to solve, perhaps we can suggest other approaches.
> 
> ## Yaw
> 
> Need ODK consultants? [https://nafundi.com](https://nafundi.com) provides form design, server  
> setup, in-field training, and software development for ODK.
> 
> > Hi? I have considered how to do what you asked.
> > 
> > 1. Delete the other specify columns that are blank when data is exported.  
> > You don't need such columns
> > 
> > Hi!
> > 
> > I do not know if it is possible but I am now trying to find the way to give  
> > the default value (numeric) for the skipped questions. Is there any  
> > possibility to do it? And if there is, could you please give me the guide  
> > with syntax? Your kindly responses are highly appreciated!
> > 
> > Thanks!
> > 
> > ## --
> > 
> > Post: [opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com)  
> > Unsubscribe: [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com)  
> > Options: [http://groups.google.com/group/opendatakit?hl=en](http://groups.google.com/group/opendatakit?hl=en)
> > 
> > * * *
> > 
> > You received this message because you are subscribed to the Google Groups  
> > "ODK Community" group.  
> > To unsubscribe from this group and stop receiving emails from it, send an  
> > email to [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> > 
> > ## --
> > 
> > Post: [opendatakit@googlegroups.com](mailto:opendatakit@googlegroups.com)  
> > Unsubscribe: [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com)  
> > Options: [http://groups.google.com/group/opendatakit?hl=en](http://groups.google.com/group/opendatakit?hl=en)
> > 
> > * * *
> > 
> > You received this message because you are subscribed to the Google Groups  
> > "ODK Community" group.  
> > To unsubscribe from this group and stop receiving emails from it, send an  
> > email to [opendatakit+unsubscribe@googlegroups.com](mailto:opendatakit+unsubscribe@googlegroups.com).  
> > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

Thank you Yaw for your response! I think I have found my way to fix it.

> **···**
>
> On Monday, November 2, 2015 at 10:12:56 AM UTC+7, Yaw Anokwa wrote: \> On Mon, Nov 2, 2015 at 1:54 AM, Louis Omoya wrote:

---

<div class="post-metadata">

**Author:** ![Lloyd\_Banwart](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/lloyd_banwart/32/1773_2.png) [@Lloyd\_Banwart](https://forum.getodk.org/u/Lloyd_Banwart)\
**Post date:** [November 2, 2015, 3:20pm UTC](https://forum.getodk.org/t/default-value-for-skipped-question/4939/5 "2015-11-02T15:20:40Z")

</div>

Can you share the proposed solution? I've toyed with the idea of building  
in defaults for questions skipped using a "pre-question" to give raw data a  
more accurate reflection for less experienced users/analysts.

For example, if you are asking about assets and you have the following  
questions:

\*A1: Do you have livestock in your household (if no skip to B1). \*

_A2: How many pigs?_

_A3: How many cows?_

\*A4: How many dragons? \*

\*B1: Do you have transportation assets? \*

If the respondent says 'no' for A1, the implied value for A2 through A4 is  
"0" but in the data it appears as system missing. It would be nice to have  
these auto fill as '0' when skipped as a result of a 'no' response to A1.  
This give a more accurate reflection of responses users/analysts/program  
staff who do not know how to treat the system missing appropriately.

~Lloyd

> **···**
>
> On Monday, November 2, 2015 at 12:42:07 AM UTC-5, kimch...@gmail.com wrote: \> \> On Monday, November 2, 2015 at 10:12:56 AM UTC+7, Yaw Anokwa wrote: \> \> You can assign defaults when you build the form, but you can't assign \> them \> \> dynamically (e.g., on skip). If you explain the high level problem you \> \> are trying to solve, perhaps we can suggest other approaches. \> \> \> \> Yaw \> \> -- \> \> Need ODK consultants? https://nafundi.com provides form design, server \> \> setup, in-field training, and software development for ODK. \> \> \> \> On Mon, Nov 2, 2015 at 1:54 AM, Louis Omoya \<louis...@gmail.com \> wrote: \> \> \> Hi? I have considered how to do what you asked. \> \> \> 1. Delete the other specify columns that are blank when data is \> exported. \> \> \> You don't need such columns \> \> \> \> \> \> Hi! \> \> \> \> \> \> I do not know if it is possible but I am now trying to find the way to \> give \> \> \> the default value (numeric) for the skipped questions. Is there any \> \> \> possibility to do it? And if there is, could you please give me the \> guide \> \> \> with syntax? Your kindly responses are highly appreciated! \> \> \> \> \> \> Thanks! \> \> \> \> \> \> -- \> \> \> -- \> \> \> Post: opend...@googlegroups.com \> \> \> Unsubscribe: opendatakit...@googlegroups.com \> \> \> Options: http://groups.google.com/group/opendatakit?hl=en \> \> \> \> \> \> --- \> \> \> You received this message because you are subscribed to the Google \> Groups \> \> \> "ODK Community" group. \> \> \> To unsubscribe from this group and stop receiving emails from it, send \> an \> \> \> email to opendatakit...@googlegroups.com . \> \> \> For more options, visit https://groups.google.com/d/optout. \> \> \> \> \> \> -- \> \> \> -- \> \> \> Post: opend...@googlegroups.com \> \> \> Unsubscribe: opendatakit...@googlegroups.com \> \> \> Options: http://groups.google.com/group/opendatakit?hl=en \> \> \> \> \> \> --- \> \> \> You received this message because you are subscribed to the Google \> Groups \> \> \> "ODK Community" group. \> \> \> To unsubscribe from this group and stop receiving emails from it, send \> an \> \> \> email to opendatakit...@googlegroups.com . \> \> \> For more options, visit https://groups.google.com/d/optout. \> \> Thank you Yaw for your response! I think I have found my way to fix it.

---

<div class="post-metadata">

**Author:** ![Kimchhoypkc](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/k/ee7513/32.png) [@Kimchhoypkc](https://forum.getodk.org/u/Kimchhoypkc)\
**Post date:** [December 1, 2015, 4:34am UTC](https://forum.getodk.org/t/default-value-for-skipped-question/4939/6 "2015-12-01T04:34:50Z")

</div>

Sorry for late reply! My way did not work. I am now trying to figure it out.

> **···**
>
> On Monday, November 2, 2015 at 7:20:40 AM UTC-8, Lloyd Owen Banwart wrote: \> Can you share the proposed solution? I've toyed with the idea of building in defaults for questions skipped using a "pre-question" to give raw data a more accurate reflection for less experienced users/analysts. \> \> \> For example, if you are asking about assets and you have the following questions: \> \> \> A1: Do you have livestock in your household (if no skip to B1). \> A2: How many pigs? \> A3: How many cows? \> A4: How many dragons? \> B1: Do you have transportation assets? \> \> \> If the respondent says 'no' for A1, the implied value for A2 through A4 is "0" but in the data it appears as system missing. It would be nice to have these auto fill as '0' when skipped as a result of a 'no' response to A1. This give a more accurate reflection of responses users/analysts/program staff who do not know how to treat the system missing appropriately. \> \> \> ~Lloyd \> \> \> On Monday, November 2, 2015 at 12:42:07 AM UTC-5, kimch...@gmail.com wrote:On Monday, November 2, 2015 at 10:12:56 AM UTC+7, Yaw Anokwa wrote: \> \> \> You can assign defaults when you build the form, but you can't assign them \> \> \> dynamically (e.g., on skip). If you explain the high level problem you \> \> \> are trying to solve, perhaps we can suggest other approaches. \> \> \> \> \> \> Yaw \> \> \> -- \> \> \> Need ODK consultants? https://nafundi.com provides form design, server \> \> \> setup, in-field training, and software development for ODK. \> \> \> \> \> \> On Mon, Nov 2, 2015 at 1:54 AM, Louis Omoya wrote: \> \> \> \> Hi? I have considered how to do what you asked. \> \> \> \> 1. Delete the other specify columns that are blank when data is exported. \> \> \> \> You don't need such columns \> \> \> \> \> \> \> \> Hi! \> \> \> \> \> \> \> \> I do not know if it is possible but I am now trying to find the way to give \> \> \> \> the default value (numeric) for the skipped questions. Is there any \> \> \> \> possibility to do it? And if there is, could you please give me the guide \> \> \> \> with syntax? Your kindly responses are highly appreciated! \> \> \> \> \> \> \> \> Thanks! \> \> \> \> \> \> \> \> -- \> \> \> \> -- \> \> \> \> Post: opend...@googlegroups.com \> \> \> \> Unsubscribe: opendatakit...@googlegroups.com \> \> \> \> Options: http://groups.google.com/group/opendatakit?hl=en \> \> \> \> \> \> \> \> --- \> \> \> \> You received this message because you are subscribed to the Google Groups \> \> \> \> "ODK Community" group. \> \> \> \> To unsubscribe from this group and stop receiving emails from it, send an \> \> \> \> email to opendatakit...@googlegroups.com. \> \> \> \> For more options, visit https://groups.google.com/d/optout. \> \> \> \> \> \> \> \> -- \> \> \> \> -- \> \> \> \> Post: opend...@googlegroups.com \> \> \> \> Unsubscribe: opendatakit...@googlegroups.com \> \> \> \> Options: http://groups.google.com/group/opendatakit?hl=en \> \> \> \> \> \> \> \> --- \> \> \> \> You received this message because you are subscribed to the Google Groups \> \> \> \> "ODK Community" group. \> \> \> \> To unsubscribe from this group and stop receiving emails from it, send an \> \> \> \> email to opendatakit...@googlegroups.com. \> \> \> \> For more options, visit https://groups.google.com/d/optout. \> \> \> \> Thank you Yaw for your response! I think I have found my way to fix it.
