# 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"
---------------------------------------------------------------------------------------------------------->

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

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"

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

## --

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

--

Smap Consulting http://smap.com.au/| Mobile Data Collection Solutions
Application Developer - neilpenman@gmail.com minqiang.huang@gmail.com
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

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"

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

## --

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

--

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

## --

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

--

"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"
---------------------------------------------------------------------------------------------------------->