Hey there

Hey yall! Happy New Year!

I need a bit of help with a form I am developing.

So...I am collecting a number of answers...all numbers.
e.g Village Population
e.g Number of Boys
e.g Number of Girls
e.g Number of Men
e.g Number of women

I have some indicators and based on the figures entered above for the
various questions. I need to produce an automated score.

To get the score, there is a range e.g 1) 0 to 5 2) 6 - 10 3)11 to 15 ...
what I want happen is as the numbers for the total boys, total girls, total
men, total women is entered I would like to automatically determine the
score....

E.g
I have
village_pop = 20
boys = 10
so [village_pop] div [boys] = 2
score should be automatically be 1 as (2 falls between the range of 0 - 5)

How can I do that

Thanks
Hope I did not confused the hell out of everyone

··· --

"Like a camera I use the negative to develop..uDig"
"Success is the ability to go from one failure to another with no loss of
enthusiasm"
---------------------------------------------------------------------------------------------------------->

Roxroy K. Bollers
GIS & IT Service Provider
tel. 592.685.2737
.........................................................
Follow Us On
Facebook http://www.facebook.com/OutSourceRox
Google+ https://plus.google.com/114064153117817313312
Twitter: @drbollers http://www.twitter.com/drbollers

Hi Roxroy,

You can try the marvellous if() function. This takes 3 parameters

  • condition
  • value if true
  • value if false

You can nest these so for example:

if(${b_ratio} = '0', 'invalid', if(${b_ratio} < 6, 1, if(${b_ratio} < 11,
2, 3)))

I put together a sample form on google drive which is my attempt at
solving your issue.

regards

Neil

··· On Wed, Jan 6, 2016 at 3:17 PM, Roxroy Bollers wrote:

Hey yall! Happy New Year!

I need a bit of help with a form I am developing.

So...I am collecting a number of answers...all numbers.
e.g Village Population
e.g Number of Boys
e.g Number of Girls
e.g Number of Men
e.g Number of women

I have some indicators and based on the figures entered above for the
various questions. I need to produce an automated score.

To get the score, there is a range e.g 1) 0 to 5 2) 6 - 10 3)11 to 15 ...
what I want happen is as the numbers for the total boys, total girls, total
men, total women is entered I would like to automatically determine the
score....

E.g
I have
village_pop = 20
boys = 10
so [village_pop] div [boys] = 2
score should be automatically be 1 as (2 falls between the range of 0 - 5)

How can I do that

Thanks
Hope I did not confused the hell out of everyone


"Like a camera I use the negative to develop..uDig"
"Success is the ability to go from one failure to another with no loss of
enthusiasm"

---------------------------------------------------------------------------------------------------------->

Roxroy K. Bollers
GIS & IT Service Provider
tel. 592.685.2737
.........................................................
Follow Us On
Facebook http://www.facebook.com/OutSourceRox
Google+ https://plus.google.com/114064153117817313312
Twitter: @drbollers http://www.twitter.com/drbollers

--

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.

--

Smap Consulting http://smap.com.au/| Mobile Data Collection Solutions
Application Developer - neilpenman@gmail.com minqiang.huang@gmail.com
Twitter: @dgmsot
Skype: ianaf4you
Phone: +61 402 975 959
Website: http://smap.com.au http://smap.com.au/blog

Thanks Neil!
I will give that a go and see.

Rox.

···

On 6 January 2016 at 00:32, Neil Penman neilpenman@gmail.com wrote:

Hi Roxroy,

You can try the marvellous if() function. This takes 3 parameters

  • condition
  • value if true
  • value if false

You can nest these so for example:

if(${b_ratio} = '0', 'invalid', if(${b_ratio} < 6, 1, if(${b_ratio} < 11,
2, 3)))

I put together a sample form on google drive which is my attempt at
solving your issue.
https://drive.google.com/file/d/0B5_SmpWlQYxvUlhQY0lFSUxzTG8/view?usp=sharing

regards

Neil

On Wed, Jan 6, 2016 at 3:17 PM, Roxroy Bollers rkbollers@gmail.com wrote:

Hey yall! Happy New Year!

I need a bit of help with a form I am developing.

So...I am collecting a number of answers...all numbers.
e.g Village Population
e.g Number of Boys
e.g Number of Girls
e.g Number of Men
e.g Number of women

I have some indicators and based on the figures entered above for the
various questions. I need to produce an automated score.

To get the score, there is a range e.g 1) 0 to 5 2) 6 - 10 3)11 to 15 ...
what I want happen is as the numbers for the total boys, total girls, total
men, total women is entered I would like to automatically determine the
score....

E.g
I have
village_pop = 20
boys = 10
so [village_pop] div [boys] = 2
score should be automatically be 1 as (2 falls between the range of 0 - 5)

How can I do that

Thanks
Hope I did not confused the hell out of everyone


"Like a camera I use the negative to develop..uDig"
"Success is the ability to go from one failure to another with no loss of
enthusiasm"

---------------------------------------------------------------------------------------------------------->

Roxroy K. Bollers
GIS & IT Service Provider
tel. 592.685.2737
.........................................................
Follow Us On
Facebook http://www.facebook.com/OutSourceRox
Google+ https://plus.google.com/114064153117817313312
Twitter: @drbollers http://www.twitter.com/drbollers

--

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.

--

Smap Consulting http://smap.com.au/| Mobile Data Collection Solutions
Application Developer - neilpenman@gmail.com minqiang.huang@gmail.com
Twitter: @dgmsot
Skype: ianaf4you
Phone: +61 402 975 959
Website: http://smap.com.au http://smap.com.au/blog

--

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.

--


"Like a camera I use the negative to develop..uDig"
"Success is the ability to go from one failure to another with no loss of
enthusiasm"
---------------------------------------------------------------------------------------------------------->

Roxroy K. Bollers
GIS & IT Service Provider
tel. 592.685.2737
.........................................................
Follow Us On
Facebook http://www.facebook.com/OutSourceRox
Google+ https://plus.google.com/114064153117817313312
Twitter: @drbollers http://www.twitter.com/drbollers