Preloading Data

Support
1

Type 'calculate'. I have entered following in the calculate column

Pulldata('preload_csv', 'april_2016', 'facilid_key', '101')

The csv with preloaded data is called preload_csv.
The column with data is 'april_2016'.
And there is a column 'facilid_id' with uniques ids 101/110.

When I convert, I get the message 'row:6 Missing calculation.

Any help to resolve the issue is much appreciated.

Louis. ...

2

Note that XLSForm expects a column called *calculation *
http://xlsform.org/

And I assume you meant pulldata(...), not Pulldata(...)
Capitalization is important.

··· On Tue, Jan 26, 2016 at 11:08 AM, Louis Omoya wrote:

Type 'calculate'. I have entered following in the calculate column

Pulldata('preload_csv', 'april_2016', 'facilid_key', '101')

The csv with preloaded data is called preload_csv.
The column with data is 'april_2016'.
And there is a column 'facilid_id' with uniques ids 101/110.

When I convert, I get the message 'row:6 Missing calculation.

Any help to resolve the issue is much appreciated.

Louis. ...

--

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.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

3

Hi,
Can someone assist me these two issues:

  1. What is the command ending a survey if the respondent does not consent
    (i.e. if the response is No, end the current survey form; if yes proceed
    with the survey)
    Question: Do you agree to participate in the survey? Response *1. YES

  2. NO*

  3. And also, another command which will allow; household listing of
    x (integer)
    members if the household size is* x.*

Thanks,
Donald.

··· On Tue, Jan 26, 2016 at 10:08 PM, Louis Omoya wrote:

Type 'calculate'. I have entered following in the calculate column

Pulldata('preload_csv', 'april_2016', 'facilid_key', '101')

The csv with preloaded data is called preload_csv.
The column with data is 'april_2016'.
And there is a column 'facilid_id' with uniques ids 101/110.

When I convert, I get the message 'row:6 Missing calculation.

Any help to resolve the issue is much appreciated.

Louis. ...

--

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.
For more options, visit https://groups.google.com/d/optout.

--
Donald Odhiambo
P.O Box 51060-00100, Nairobi, Kenya
Cell: +254-727-705-052 | +254-731-705-052
Emails: donald@tecttona.com | infodonaldo@gmail.com

4

To end survey if response is no
Use begin_group And end_group.
All questions relevant if response is yes will be in that group.
Apply constraint e.g ${consent}= '1'.
Ot just put the above in all constraint for questions relevant if
respondent agrees.

Use repeat count column and specify how many times field for names of hh
members should appear.

··· On 27 Jan 2016 12:38, "Donald Odhiambo" wrote:

Hi,
Can someone assist me these two issues:

  1. What is the command ending a survey if the respondent does not consent
    (i.e. if the response is No, end the current survey form; if yes proceed
    with the survey)
    Question: Do you agree to participate in the survey? Response *1. YES

  2. NO*

  3. And also, another command which will allow; household listing of x (integer)
    members if the household size is* x.*

Thanks,
Donald.

On Tue, Jan 26, 2016 at 10:08 PM, Louis Omoya louisomoya@gmail.com wrote:

Type 'calculate'. I have entered following in the calculate column

Pulldata('preload_csv', 'april_2016', 'facilid_key', '101')

The csv with preloaded data is called preload_csv.
The column with data is 'april_2016'.
And there is a column 'facilid_id' with uniques ids 101/110.

When I convert, I get the message 'row:6 Missing calculation.

Any help to resolve the issue is much appreciated.

Louis. ...

--

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.
For more options, visit https://groups.google.com/d/optout.

--
Donald Odhiambo
P.O Box 51060-00100, Nairobi, Kenya
Cell: +254-727-705-052 | +254-731-705-052
Emails: donald@tecttona.com | infodonaldo@gmail.com

--

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.
For more options, visit https://groups.google.com/d/optout.

5

To end survey if response is no
Use begin_group And end_group.
All questions relevant if response is yes will be in that group.
Apply constraint e.g ${consent}= '1'.
Ot just put the above in all constraint for questions relevant if
respondent agrees.

Use repeat count column and specify how many times field for names of hh
members should appear.

Hi,
Can someone assist me these two issues:

  1. What is the command ending a survey if the respondent does not consent
    (i.e. if the response is No, end the current survey form; if yes proceed
    with the survey)
    Question: Do you agree to participate in the survey? Response *1. YES

  2. NO*

  3. And also, another command which will allow; household listing of
    x (integer)
    members if the household size is* x.*

Thanks,
Donald.

··· On 27 Jan 2016 12:38, "Donald Odhiambo" wrote:

On Tue, Jan 26, 2016 at 10:08 PM, Louis Omoya louisomoya@gmail.com wrote:

Type 'calculate'. I have entered following in the calculate column

Pulldata('preload_csv', 'april_2016', 'facilid_key', '101')

The csv with preloaded data is called preload_csv.
The column with data is 'april_2016'.
And there is a column 'facilid_id' with uniques ids 101/110.

When I convert, I get the message 'row:6 Missing calculation.

Any help to resolve the issue is much appreciated.

Louis. ...

--

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.
For more options, visit https://groups.google.com/d/optout.

--
Donald Odhiambo
P.O Box 51060-00100, Nairobi, Kenya
Cell: +254-727-705-052 | +254-731-705-052
Emails: donald@tecttona.com | infodonaldo@gmail.com

--

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.
For more options, visit https://groups.google.com/d/optout.