Hi all!
I've checked the forum in vain, I'm still not happy.
I need to collect data for children aged 2mo - 5 yrs at inclusion. If the exact date of birth is unknown we mark 09-09-2099 and write the approximate age in months.
I tried the enclosed example. I've checked the date() and decimal-date() functions but they didn't work.
What's wrong with my formula? How to proceed?
Many thanks.
···
--
Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.
On Tue, Sep 16, 2014 at 7:05 AM, Serge Somda manituo@gmail.com wrote:
Hi all!
I've checked the forum in vain, I'm still not happy.
I need to collect data for children aged 2mo - 5 yrs at inclusion. If the exact date of birth is unknown we mark 09-09-2099 and write the approximate age in months.
I tried the enclosed example. I've checked the date() and decimal-date() functions but they didn't work.
What's wrong with my formula? How to proceed?
Many thanks.
1 -> The default date of birth works on enketo but not on odk collect
2 -> The date of birth '09/09/2099' is considered as an illegal value
3 -> Naturally the relevant field for the age does not work
4 -> The age is not automatically computed.
Regards.
Serge
···
2014-09-16 16:08 GMT+02:00 Yaw Anokwa :
Serge,
What precisely is wrong with the form
Yaw
Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.
On Tue, Sep 16, 2014 at 7:05 AM, Serge Somda manituo@gmail.com wrote:
Hi all!
I've checked the forum in vain, I'm still not happy.
I need to collect data for children aged 2mo - 5 yrs at inclusion. If
the exact date of birth is unknown we mark 09-09-2099 and write the
approximate age in months.
I tried the enclosed example. I've checked the date() and decimal-date()
functions but they didn't work.
What's wrong with my formula? How to proceed?
Many thanks.
When troubleshooting, break down the problem into smaller chunks. I
find that, plus a combination of debug variables using calculates and
outputs helps a lot. I found five problems with your form.
The date format you use is not correct. "2014-12-31" is the correct format.
When you subtract days from dates, wrap the operation like so:
"date(${date_obs} - 60)"
Division is done with div, not /. For example, "10 div 2" will give you 5.
Defaults cannot contain variables or commands. If you want get
dynamic 'default', use the calculation column.
Age should probably be an integer since div will give you an overly
precise number (e.g, 12.21321412512)
···
--
Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.
On Tue, Sep 16, 2014 at 7:19 AM, M. A. Serge SOMDA manituo@gmail.com wrote:
1 -> The default date of birth works on enketo but not on odk collect
2 -> The date of birth '09/09/2099' is considered as an illegal value
3 -> Naturally the relevant field for the age does not work
4 -> The age is not automatically computed.
Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.
On Tue, Sep 16, 2014 at 7:05 AM, Serge Somda manituo@gmail.com wrote:
Hi all!
I've checked the forum in vain, I'm still not happy.
I need to collect data for children aged 2mo - 5 yrs at inclusion. If
the exact date of birth is unknown we mark 09-09-2099 and write the
approximate age in months.
I tried the enclosed example. I've checked the date() and decimal-date()
functions but they didn't work.
What's wrong with my formula? How to proceed?
Many thanks.
Wonderfull. Several points have been solved.
But the legal value "2099-09-09" still doesn't work. This works properly on
enketo but not with ODK collect.
A widget is displayed and when I enter "09 -- sep -- 2099" it returns the
error message.
Is it possible to force a simple date entry "2099-09-09" in the place of
the widget, this would be simpler.
Many thanks.
Serge
···
2014-09-17 8:42 GMT+02:00 Yaw Anokwa :
Hi Serge,
When troubleshooting, break down the problem into smaller chunks. I
find that, plus a combination of debug variables using calculates and
outputs helps a lot. I found five problems with your form.
The date format you use is not correct. "2014-12-31" is the correct
format.
When you subtract days from dates, wrap the operation like so:
"date(${date_obs} - 60)"
Division is done with div, not /. For example, "10 div 2" will give you
Defaults cannot contain variables or commands. If you want get
dynamic 'default', use the calculation column.
Age should probably be an integer since div will give you an overly
precise number (e.g, 12.21321412512)
Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.
On Tue, Sep 16, 2014 at 7:19 AM, M. A. Serge SOMDA manituo@gmail.com wrote:
1 -> The default date of birth works on enketo but not on odk collect
2 -> The date of birth '09/09/2099' is considered as an illegal value
3 -> Naturally the relevant field for the age does not work
4 -> The age is not automatically computed.
Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.
On Tue, Sep 16, 2014 at 7:05 AM, Serge Somda manituo@gmail.com wrote:
Hi all!
I've checked the forum in vain, I'm still not happy.
I need to collect data for children aged 2mo - 5 yrs at inclusion. If
the exact date of birth is unknown we mark 09-09-2099 and write the
approximate age in months.
I tried the enclosed example. I've checked the date() and
decimal-date()
functions but they didn't work.
What's wrong with my formula? How to proceed?
Many thanks.