Help me. XLS FORM: TIME

Hi to everybody

I have a problem with my xlsform. If I insert the Time as question, when I
fill the question with for example 07:00, the result that I find in the
answer is 05:00. It means that all the times in the filled forms are wrong
and they are all two hours behind the time you entered. How can I solve
this problem?

And another question, why if I insert Date as a question, in the filled
forms I have both Date and time (the time is always 00:00). I want only the
date and not the time in this field.

thanks

Laura

Dates and times are converted and displayed in UTC on ODK Aggregate.

··· On Wed, Sep 23, 2015 at 3:12 AM, Laura Carcano wrote:

Hi to everybody

I have a problem with my xlsform. If I insert the Time as question, when I
fill the question with for example 07:00, the result that I find in the
answer is 05:00. It means that all the times in the filled forms are wrong
and they are all two hours behind the time you entered. How can I solve
this problem?

And another question, why if I insert Date as a question, in the filled
forms I have both Date and time (the time is always 00:00). I want only the
date and not the time in this field.

thanks

Laura

--

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

Laura,

If you are looking for an alternative, use selects (e.g. from 00-23
for hours) or integers with constraints to capture time. You can use
something similar for dates, but if you aren't careful, you risk
getting an invalid date (e.g.. Feb 29th on a non-leap year).

Yaw

··· -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Thu, Sep 24, 2015 at 2:27 AM, Mitch Sundt mitchellsundt@gmail.com wrote:

Dates and times are converted and displayed in UTC on ODK Aggregate.

On Wed, Sep 23, 2015 at 3:12 AM, Laura Carcano lau.carcano@gmail.com wrote:

Hi to everybody

I have a problem with my xlsform. If I insert the Time as question, when I
fill the question with for example 07:00, the result that I find in the
answer is 05:00. It means that all the times in the filled forms are wrong
and they are all two hours behind the time you entered. How can I solve this
problem?

And another question, why if I insert Date as a question, in the filled
forms I have both Date and time (the time is always 00:00). I want only the
date and not the time in this field.

thanks

Laura

--

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

--

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.

Hi, thank you very much for your answer. How can I insert the 'Captured
time' selection?
I copy here my xls form. The row is 7.

[image: Immagine incorporata 2]

··· 2015-09-24 11:18 GMT+02:00 Yaw Anokwa :

Laura,

If you are looking for an alternative, use selects (e.g. from 00-23
for hours) or integers with constraints to capture time. You can use
something similar for dates, but if you aren't careful, you risk
getting an invalid date (e.g.. Feb 29th on a non-leap year).

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Thu, Sep 24, 2015 at 2:27 AM, Mitch Sundt mitchellsundt@gmail.com wrote:

Dates and times are converted and displayed in UTC on ODK Aggregate.

On Wed, Sep 23, 2015 at 3:12 AM, Laura Carcano lau.carcano@gmail.com wrote:

Hi to everybody

I have a problem with my xlsform. If I insert the Time as question,
when I
fill the question with for example 07:00, the result that I find in the
answer is 05:00. It means that all the times in the filled forms are
wrong
and they are all two hours behind the time you entered. How can I solve
this
problem?

And another question, why if I insert Date as a question, in the filled
forms I have both Date and time (the time is always 00:00). I want only
the
date and not the time in this field.

thanks

Laura

--

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

--

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.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/6tNhwMIHzYU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Laura,

Use two selects that are wrapped with a group with the field-list
appearance. For hour, use a select with choices that range from 00-23. For
minute, use a select with choices that range from 00-59.

Yaw

··· -- Need ODK services? http://nafundi.com provides form design, server setup, professional support, and software development for ODK.

On Thu, Sep 24, 2015 at 4:24 PM, Laura Carcano lau.carcano@gmail.com wrote:

Hi, thank you very much for your answer. How can I insert the 'Captured
time' selection?
I copy here my xls form. The row is 7.

[image: Immagine incorporata 2]

2015-09-24 11:18 GMT+02:00 Yaw Anokwa yanokwa@nafundi.com:

Laura,

If you are looking for an alternative, use selects (e.g. from 00-23
for hours) or integers with constraints to capture time. You can use
something similar for dates, but if you aren't careful, you risk
getting an invalid date (e.g.. Feb 29th on a non-leap year).

Yaw

Need ODK services? http://nafundi.com provides form design, server
setup, professional support, and software development for ODK.

On Thu, Sep 24, 2015 at 2:27 AM, Mitch Sundt mitchellsundt@gmail.com wrote:

Dates and times are converted and displayed in UTC on ODK Aggregate.

On Wed, Sep 23, 2015 at 3:12 AM, Laura Carcano lau.carcano@gmail.com wrote:

Hi to everybody

I have a problem with my xlsform. If I insert the Time as question,
when I
fill the question with for example 07:00, the result that I find in the
answer is 05:00. It means that all the times in the filled forms are
wrong
and they are all two hours behind the time you entered. How can I
solve this
problem?

And another question, why if I insert Date as a question, in the filled
forms I have both Date and time (the time is always 00:00). I want
only the
date and not the time in this field.

thanks

Laura

--

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

--

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.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/6tNhwMIHzYU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

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.