DOB field and Age field combo

Hi Friends,

I would like to have a DOB and Age fields in one of my forms, and if a
respondent enters DOB it will save DOB, if a respondent enters Age it
should convert that to DOB and save on the table. Is there any way to
accomplish that?

Thanks,
Imran

Hi Imran,

Attached is a sample form that asks a user to pick DOB or age. If they
select DOB, it estimates age. If they select age, it estimates DOB.

Dates are tricky and I didn't spend a ton of time on this, so you
should test edge cases and make sure it does what you want.

Yaw

dob_age.xlsx (32.9 KB)

··· On Sun, Jan 29, 2017 at 1:25 PM, A.N.M AL-IMRAN wrote: > Hi Friends, > > I would like to have a DOB and Age fields in one of my forms, and if a > respondent enters DOB it will save DOB, if a respondent enters Age it should > convert that to DOB and save on the table. Is there any way to accomplish > that? > > Thanks, > Imran > > -- > -- > 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.

Dear Yaw,

This is an excellent and very helpful example. Consequently, a question
came to my mind: is there a way to hide the note column on Aggregate?

Regards,
Imran

A N M AL IMRAN (Imran)
Brossard, QC
Canada
Cell: +1 (438) 501 3576

··· On 3 February 2017 at 12:10, A.N.M AL-IMRAN wrote:

Dear Yaw,

This is an excellent and very helpful example. Consequently, a question
came to my mind: is there a way to the note column?

Regards,
Imran

A N M AL IMRAN (Imran)
Brossard, QC
Canada
Cell: +1 (438) 501 3576 <+1%20438-501-3576>

On 3 February 2017 at 01:04, Yaw Anokwa yanokwa@nafundi.com wrote:

Hi Imran,

Attached is a sample form that asks a user to pick DOB or age. If they
select DOB, it estimates age. If they select age, it estimates DOB.

Dates are tricky and I didn't spend a ton of time on this, so you
should test edge cases and make sure it does what you want.

Yaw

On Sun, Jan 29, 2017 at 1:25 PM, A.N.M AL-IMRAN imran3may@gmail.com wrote:

Hi Friends,

I would like to have a DOB and Age fields in one of my forms, and if a
respondent enters DOB it will save DOB, if a respondent enters Age it
should
convert that to DOB and save on the table. Is there any way to
accomplish
that?

Thanks,
Imran

--

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/to
pic/opendatakit/NhlmpTs4FYo/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.

Imran,

You can use the Filter feature in Aggregate to hide whatever rows or
columns you want.

Yaw

··· On Sat, Feb 4, 2017 at 12:11 AM, A.N.M AL-IMRAN wrote: > Dear Yaw, > > This is an excellent and very helpful example. Consequently, a question came > to my mind: is there a way to hide the note column on Aggregate? > > Regards, > Imran > > > A N M AL IMRAN (Imran) > Brossard, QC > Canada > Cell: +1 (438) 501 3576 > > On 3 February 2017 at 12:10, A.N.M AL-IMRAN wrote: >> >> Dear Yaw, >> >> This is an excellent and very helpful example. Consequently, a question >> came to my mind: is there a way to the note column? >> >> Regards, >> Imran >> >> >> A N M AL IMRAN (Imran) >> Brossard, QC >> Canada >> Cell: +1 (438) 501 3576 >> >> On 3 February 2017 at 01:04, Yaw Anokwa wrote: >>> >>> Hi Imran, >>> >>> Attached is a sample form that asks a user to pick DOB or age. If they >>> select DOB, it estimates age. If they select age, it estimates DOB. >>> >>> Dates are tricky and I didn't spend a ton of time on this, so you >>> should test edge cases and make sure it does what you want. >>> >>> Yaw >>> >>> >>> On Sun, Jan 29, 2017 at 1:25 PM, A.N.M AL-IMRAN wrote: >>> > Hi Friends, >>> > >>> > I would like to have a DOB and Age fields in one of my forms, and if a >>> > respondent enters DOB it will save DOB, if a respondent enters Age it >>> > should >>> > convert that to DOB and save on the table. Is there any way to >>> > accomplish >>> > that? >>> > >>> > Thanks, >>> > Imran >>> > >>> > -- >>> > -- >>> > 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/NhlmpTs4FYo/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.

Thanks, Yaw. Yes that works.

Imran

A N M AL IMRAN (Imran)
Brossard, QC
Canada
Cell: +1 (438) 501 3576

··· On 6 February 2017 at 00:56, Yaw Anokwa wrote:

Imran,

You can use the Filter feature in Aggregate to hide whatever rows or
columns you want.

Yaw

On Sat, Feb 4, 2017 at 12:11 AM, A.N.M AL-IMRAN imran3may@gmail.com wrote:

Dear Yaw,

This is an excellent and very helpful example. Consequently, a question
came
to my mind: is there a way to hide the note column on Aggregate?

Regards,
Imran

A N M AL IMRAN (Imran)
Brossard, QC
Canada
Cell: +1 (438) 501 3576

On 3 February 2017 at 12:10, A.N.M AL-IMRAN imran3may@gmail.com wrote:

Dear Yaw,

This is an excellent and very helpful example. Consequently, a question
came to my mind: is there a way to the note column?

Regards,
Imran

A N M AL IMRAN (Imran)
Brossard, QC
Canada
Cell: +1 (438) 501 3576

On 3 February 2017 at 01:04, Yaw Anokwa yanokwa@nafundi.com wrote:

Hi Imran,

Attached is a sample form that asks a user to pick DOB or age. If they
select DOB, it estimates age. If they select age, it estimates DOB.

Dates are tricky and I didn't spend a ton of time on this, so you
should test edge cases and make sure it does what you want.

Yaw

On Sun, Jan 29, 2017 at 1:25 PM, A.N.M AL-IMRAN imran3may@gmail.com wrote:

Hi Friends,

I would like to have a DOB and Age fields in one of my forms, and if
a

respondent enters DOB it will save DOB, if a respondent enters Age it
should
convert that to DOB and save on the table. Is there any way to
accomplish
that?

Thanks,
Imran

--

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/NhlmpTs4FYo/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.

--

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/NhlmpTs4FYo/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.