XLSFormDesign-Multiple_visits_same_record

Hi All-
I am having a bit of trouble designing a form for data collection at a nest
box. I am having two main struggles

One I am using repeat to group a set of questions that need to be answered
everytime a person goes out and monitors a nest. There will be maybe 10
visits a season. Right now the only way I can figure to do this is to keep
the same form on a device and have the monitor edit the form multiple times
over the season. Is there a better way to do this?

Second there is a set of questions for the monitoring that only has to
happen the last visit of the season. I am using select_one yes_no to try to
skip this group of questions if the answer to "Is this the final visit of
the season?" is no. I am using the constraints on the questions to
accomplish this. However, because several of the questions are data fields
it is giving me an error as invalid entry because it is trying to record a
date when I said to skip this question if I answer no. Is there a way to
have the default of a data field be null.

Also in the mobile is there a way to deselect a select_one data type once
it has been selected.

I have attached two forms to this post. The form I am trying to recreate in
ODK Collect (NW_DataSheet_2013.pdf) and my latest attempt in XLSform
(nextbox7714.xls)

Any thoughts or suggestions would be greatly appreciated.

Thanks,
Cyndi Dawson
Environmental Scientist
Asilomar State Beach & Conference Grounds
CA State Parks

nextbox7714.xls (51.5 KB)

NW_DataSheet_2013.pdf (791 KB)

Hi Cyndi,

An alternative approach would be to create 3 forms:

  1. the initial questions that include the GPS, species, etc
  2. the survey data that needs to be filled in every visit
  3. the questions of the final visit.

On each form, you would have to include the nest id so you can relate the
data afterwards.
Advantage is that the data is not kept on the mobile, but sent to the
server each time. It also might be easier for the monitors, as they don't
have to browse and find the specific form they want to edit.

Regarding the errors on the date field. To skip questions, you have to use
the 'relevant' column instead of the 'constraint'. The correct notation to
skip those questions is: ${finalvisit} = 'yes'
You can use this same technique to automatically skip other questions like:
human_modifiedone

Also note that the values in the 'name' column of the choices sheet
shouldn't contain spaces.

Hope this is helpful.
best,
Olaf

··· --- olaf.veerman@flipside.org flipside.org +351 926 5264 65

On 8 July 2014 00:45, Asilomar Nrm asilomares@gmail.com wrote:

Hi All-
I am having a bit of trouble designing a form for data collection at a
nest box. I am having two main struggles

One I am using repeat to group a set of questions that need to be answered
everytime a person goes out and monitors a nest. There will be maybe 10
visits a season. Right now the only way I can figure to do this is to keep
the same form on a device and have the monitor edit the form multiple times
over the season. Is there a better way to do this?

Second there is a set of questions for the monitoring that only has to
happen the last visit of the season. I am using select_one yes_no to try to
skip this group of questions if the answer to "Is this the final visit of
the season?" is no. I am using the constraints on the questions to
accomplish this. However, because several of the questions are data fields
it is giving me an error as invalid entry because it is trying to record a
date when I said to skip this question if I answer no. Is there a way to
have the default of a data field be null.

Also in the mobile is there a way to deselect a select_one data type once
it has been selected.

I have attached two forms to this post. The form I am trying to recreate
in ODK Collect (NW_DataSheet_2013.pdf) and my latest attempt in XLSform
(nextbox7714.xls)

Any thoughts or suggestions would be greatly appreciated.

Thanks,
Cyndi Dawson
Environmental Scientist
Asilomar State Beach & Conference Grounds
CA State Parks

--

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 Olaf and Mitch. Using the relevant column and the syntax Mitch
suggested worked to skip over the date fields. Totally helpful thanks!!

··· On Monday, July 7, 2014 4:45:51 PM UTC-7, Asilomar Nrm wrote: > > Hi All- > I am having a bit of trouble designing a form for data collection at a > nest box. I am having two main struggles > > One I am using repeat to group a set of questions that need to be answered > everytime a person goes out and monitors a nest. There will be maybe 10 > visits a season. Right now the only way I can figure to do this is to keep > the same form on a device and have the monitor edit the form multiple times > over the season. Is there a better way to do this? > > Second there is a set of questions for the monitoring that only has to > happen the last visit of the season. I am using select_one yes_no to try to > skip this group of questions if the answer to "Is this the final visit of > the season?" is no. I am using the constraints on the questions to > accomplish this. However, because several of the questions are data fields > it is giving me an error as invalid entry because it is trying to record a > date when I said to skip this question if I answer no. Is there a way to > have the default of a data field be null. > > Also in the mobile is there a way to deselect a select_one data type once > it has been selected. > > I have attached two forms to this post. The form I am trying to recreate > in ODK Collect (NW_DataSheet_2013.pdf) and my latest attempt in XLSform > (nextbox7714.xls) > > Any thoughts or suggestions would be greatly appreciated. > > Thanks, > Cyndi Dawson > Environmental Scientist > Asilomar State Beach & Conference Grounds > CA State Parks >

If you long-press anywhere on the select-one choices, you will get a pop-up
in which you can 'Remove Response' to deselect your choice.

If you simply do not specify a default value for date, it will be null.

When the date question is first presented, it will show as the current date
(always).

Advancing will always store the displayed value, so there is no way to
advance without saving a non-null date.

If this is important, you will need to have a select-one asking whether the
user wants to supply a date, and make displaying the date field conditional
on that response.

··· On Tue, Jul 8, 2014 at 2:10 AM, Olaf Veerman wrote:

Hi Cyndi,

An alternative approach would be to create 3 forms:

  1. the initial questions that include the GPS, species, etc
  2. the survey data that needs to be filled in every visit
  3. the questions of the final visit.

On each form, you would have to include the nest id so you can relate the
data afterwards.
Advantage is that the data is not kept on the mobile, but sent to the
server each time. It also might be easier for the monitors, as they don't
have to browse and find the specific form they want to edit.

Regarding the errors on the date field. To skip questions, you have to use
the 'relevant' column instead of the 'constraint'. The correct notation to
skip those questions is: ${finalvisit} = 'yes'
You can use this same technique to automatically skip other questions
like: human_modifiedone

Also note that the values in the 'name' column of the choices sheet
shouldn't contain spaces.

Hope this is helpful.
best,
Olaf


olaf.veerman@flipside.org
flipside.org http://www.flipside.org
+351 926 5264 65

On 8 July 2014 00:45, Asilomar Nrm asilomares@gmail.com wrote:

Hi All-
I am having a bit of trouble designing a form for data collection at a
nest box. I am having two main struggles

One I am using repeat to group a set of questions that need to be
answered everytime a person goes out and monitors a nest. There will be
maybe 10 visits a season. Right now the only way I can figure to do this is
to keep the same form on a device and have the monitor edit the form
multiple times over the season. Is there a better way to do this?

Second there is a set of questions for the monitoring that only has to
happen the last visit of the season. I am using select_one yes_no to try to
skip this group of questions if the answer to "Is this the final visit of
the season?" is no. I am using the constraints on the questions to
accomplish this. However, because several of the questions are data fields
it is giving me an error as invalid entry because it is trying to record a
date when I said to skip this question if I answer no. Is there a way to
have the default of a data field be null.

Also in the mobile is there a way to deselect a select_one data type once
it has been selected.

I have attached two forms to this post. The form I am trying to recreate
in ODK Collect (NW_DataSheet_2013.pdf) and my latest attempt in XLSform
(nextbox7714.xls)

Any thoughts or suggestions would be greatly appreciated.

Thanks,
Cyndi Dawson
Environmental Scientist
Asilomar State Beach & Conference Grounds
CA State Parks

--

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